Page 473 - Excel 2007 Bible

27_044039 ch21.qxp 11/21/06 11:12 AM Page 430
Part III
Creating Charts and Graphics
FIGURE 21.9
This worksheet, which uses color scale conditional formatting, is zoomed to 20%.
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 cells.
To assign an icon set to a range, select the cells and choose Home ➪ Styles ➪ Conditional Formatting ➪
Icon Sets. Excel provides 17 icon sets to choose from (and you can’t create your set of icons). The number
of icons in the sets ranges from 3 to 5.
An icon set example
Figure 21.10 shows a simple example that uses the icon set named Three Symbols (Uncircled). The symbols
graphically depict the status of each project, based on the value in column C.
All the icon set examples in this section are available on the companion CD-ROM. The work-
ON the CD-ROM book is named icon set examples.xlsx.
ON the CD-ROM

FIGURE 21.10
Using an icon set to indicate the status of projects.

430