338 Chapter 11 Change Workbook Appearance
In the Edit Formatting Rule dialog box, you can customize conditional formatting.- Click the Reverse Icon Order button.
Excel reconfigures the rules so the red light icon is at the top and the green light
icon is at the bottom.- In the red light icon’s row, in the Type list, click Number.
- In the red light icon’s Value field, type 0.7.
- In the yellow light icon’s row, in the Type list, click Number.
- In the yellow light icon Value field, type 0.5.
- Click OK twice to close the Edit Formatting Rule dialog box and the Conditional
Formatting Rules Manager.
Excel formats the selected cell range. - Click cell C15.
- 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. - In the left field, type 96%.
- In the With list, click Red text.