Page 474 - Excel 2007 Bible

27_044039 ch21.qxp 11/21/06 11:12 AM Page 431
By default, the symbols are assigned using percentiles. For a 3-symbol set, the items are grouped into three
percentiles. For a 4-symbol set, they’re grouped into 4 percentiles. And for a 5-symbol set, the items are
grouped into five percentiles.
If you would like more control over how the icons are assigned, choose Home ➪ Styles ➪ Conditional
Formatting ➪ Icon Sets ➪ More Rules to display the New Formatting Rule dialog box. Figure 21.11 shows
how to modify the icon set rules such that only projects that are 100% completed get the check mark icons.
Projects which are 0% completed get the X icon. All other projects get the exclamation point icon.
Figure 21.12 shows the task list after making this change.
FIGURE 21.11
Changing the icon assignment rule.

FIGURE 21.12 Visualizing Data Using Conditional Formatting 21
Using a customized icon set to indicate the status of projects.

431