Microsoft Office Tutorials and References
In Depth Information
Using icon sets
An extreme color scale example
It’s important to understand that color scale conditional formatting uses a gradient. For
example, if you format a range using a two-color scale, you’fill get a lot more than two
colors. You’fill also get colors within the gradient between the two speciﬁ ed colors.
Figure 19.18 shows an extreme example that uses color scale conditional formatting on a
range of more than 6,000 cells. The worksheet contains average daily temperatures for an
18-year period. Each row contains 365 (or 366) temperatures for the year. The columns are
very narrow so the entire year can be visualized.
This worksheet uses color scale conditional formatting to display daily temperatures.
Using icon sets
Yet another conditional formatting option is to display an icon in the cell. The icon
displayed depends on the value of the cell.
To assign an icon set to a range, select the cells and choose Home
Formatting ➪ Icon Sets. Excel provides 20 icon sets to choose from. The number of icons in
the sets ranges from three to ﬁ ve. You can’t create a custom icon set.
An icon set example
Figure 19.19 shows an example that uses an icon set. The symbols graphically depict the
status of each project, based on the value in column C.
By default, the symbols are assigned using percentiles. For a three-symbol set, the items
are grouped into three percentiles. For a four-symbol set, they’re grouped into four
percentiles. And for a ﬁ ve-symbol set, the items are grouped into ﬁ ve percentiles.