Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
h Icon Sets: This displays icons directly in the cells. The icons depend on the cells’ values.
h New Rule: This enables you to specify other conditional formatting rules, including rules
based on a logical formula.
h Clear Rules: This deletes all the conditional formatting rules from the selected cells.
h Manage Rules: This displays the Conditional Formatting Rules Manager dialog box, in
which you create new conditional formatting rules, edit rules, or delete rules.
Figure 19-1: This worksheet demonstrates a few conditional formatting rules.