Microsoft Office Tutorials and References
In Depth Information
4. Click on the type of conditional formatting you want.
Excel applies your conditional formatting over the cells you chose in
Creating conditional formatting rules
Using colors or icons to identify ranges of values might be nice, but you may
want to define your own rules for how conditional formatting should work,
such as displaying all negative values in red and all values above 1,000 in
To define your own rules for formatting values, follow these steps:
1. Select the cells that you want to apply conditional formatting.
2. Click the Home tab and then click the Conditional Formatting icon in
the Styles group.
A menu appears (refer to Figure 9-6).
3. Move the mouse over Highlight Cells Rules.
A menu appears, as shown in Figure 9-7.
4. Click on an option such as Greater Than or Between.
A dialog box appears, which lets you define one or more values and
choose a color for formatting your selected cells, as shown in Figure 9-8.