Microsoft Office Tutorials and References
In Depth Information
Analyze Cell Values with Icon Sets
Chapter 5: Analyzing Excel Data
5 Click the type of icon set
you want to apply.
The categories include
Indicators, and Ratings.
Excel applies the icons to
each cell in the range.
Did You Know?
The Excel icon sets come in four categories:
Directional, Shapes, Indicators, and Ratings.
Use Directional icon sets for indicating
trends and data movement; use Shapes
icon sets for pointing out the high (green)
and low (red) values; Use Indicators to add
value judgments; and use Ratings to show
where each cell resides in the overall range
of data values.
If you no longer require an icon set, you
can remove it. Follow steps 1 to 3 to
select the range and display the
Conditional Formatting drop-down
menu, and then click Manage Rules.
Excel displays the Conditional Formatting
Rules Manager dialog box. Click the Icon
Set rule you want to remove and then
click Delete Rule.