Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
In some cases, you may want to hide one or more icons from an icon set. Displaying an icon for
every cell in a range might result in visual overload. Figure 19-14 shows the test results table after
hiding the level arrow by choosing No Cell Icon in the Edit Formatting Rule dialog box.
Figure 19-14: Displaying only two icons from a three-icon set.
Working with conditional formats
This section describes some additional information about conditional formatting that you may
The Conditional Formatting Rules Manager dialog box is useful for checking, editing, deleting,
and adding conditional formats. Access this dialog box by choosing Home ➜ Styles ➜ Conditional
Formatting ➜ Manage Rules.
You can specify as many rules as you like by clicking the New Rule button. As you can see in
Figure 19-15, cells can even use data bars, color scales, and icon sets all at the same time —
although I can’t think of a good reason to do so.