Microsoft Office Tutorials and References
In Depth Information
Highlighting Trends and Variations in Data
● Icon Sets This is the most visually diverse (and potentially cringe-inducing) of all
the preset conditional formatting options. You can choose from arrows, circles and
other shapes, lags, and rating scales made up of stars and clocks and bars, like the
ones shown here.
If none of the preset options match your needs, you can create custom rules from scratch.
In some cases, you might start with a preset rule and then, after applying it to the selection,
modify the rule. If you click More Rules at the bottom of any of the Conditional Formatting
menu options, you get the New Formatting Rule dialog box. If you’ve already defined rules
and want to adjust them, click Conditional Formatting (in the Styles group on the Home
tab) and then click Manage Rules. That opens the Conditional Formatting Rules Manager
dialog box, shown in Figure 13-19.
Figure 13-19 You can expand or restrict the display of rules here by using the drop-down list at
the top of the dialog box.
To edit an existing rule, select its entry in the Conditional Formatting Rules Manager dialog
box and click Edit Rule. The exact options you see here vary, depending on the type of rule
you originally created. In the example shown here, we tweaked an Icon Set rule so that it
hides the underlying value and shows only the icon. We also adjusted the rules for each
icon from their default percentages to a purely numeric scheme.