Microsoft Office Tutorials and References
In Depth Information
9. Click the Reverse Icon Order button.
Excel reconigures 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, type 0.7 .
12. In the yellow light icon’s row, in the Type list, click Number .
13. In the yellow light icon Value field, type 0.5 .
14. Click OK twice to close the Edit Formatting Rule dialog box and the Conditional
Formatting Rules Manager .
Excel formats 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 .
The Less Than dialog box opens.
17. In the left field, type 96% .
18. In the With list, click Red text .
Search JabSto ::




Custom Search