Microsoft Office Tutorials and References
In Depth Information
Changing the appearance of data
9 Click the Reverse Icon Order button to reconigure the rules so the red light icon is
at the top and the green light icon is at the bottom.
10 In the red light icon’s row, in the Type list, click Number .
11 In the red light icon’s Value field, enter 0.7 .
12 In the yellow light icon’s row, in the Type list, click Number .
13 In the yellow light icon Value field, enter 0.5 .
14 Click OK twice to close the Edit Formatting Rule dialog box and the Conditional
Formatting Rules Manager to apply the format to the selected cell range.
15 Click cell C15 .
16 On the Home tab, in the Styles group, click Conditional Formatting . On the menu,
point to Highlight Cells Rules , and then click Less Than to open the Less Than
17 In the left field, enter 96%.
In the With list, click Red text .