Excel Icon Sets
Icon Sets
With Excel, you can add icons to cells inside a range to show how big the values in those cells are in relation to the other values in the range. These readymade conditional formatting sets are called icon sets.
It is possible to combine Icon Sets with other conditional formatting rules.
Icon Sets Options
Excel offers several distinct icon sets that are arranged as follows:
Directional
Shapes
Indicators
Ratings
Icon Set Formatting Example
Using Icon Set conditional formatting, you may add icons to each Pokemon’s Speed value.
Icon Sets, in detail:
- Choose the Speed value range. C2:C10
2. From the Home menu, select the Conditional Formatting icon 
in the ribbon.
3. Pick Icon Sets from the selection that drops down.
4. Select the option “3 Traffic Lights (Unrimmed)”.
The icons in the Speed value cells will now show how big the values are in relation to the other values in the range:
For the highest values, the traffic light is green; for the middle values, it is yellow; and for the lowest values, it is red.
Excel computes and selects the values that receive the appropriate colored traffic light icon automatically.
Note: Manage Rules allows you to remove the Highlight Cell Rules.
