... to have cell color GREEN if points>90, color BLUE if points>80, color BLACK if points>70, color PURPLE if points >64, and color RED if points <=64. Thanks very much
Answers (1)
Highlight your cell or range of cells.
From the Format menu, select Conditional Formatting…
In the Conditional formatting dialog, select Cell Value Is in the first drop-down box.
Select a cell evaluator from the second drop down box. Your dialog may change and add another field.
Enter your values in the remaining text boxes.
Click the Format… button.
Choose your format options from the Font, Border and Patterns tabs.
Click OK.
Click OK or add another condition.