Microsoft Office Tutorials and References
In Depth Information
Figure 19-9: Using an icon set to indicate the status of projects.
By default, the symbols are assigned using percentiles. For a 3-symbol set, the items are grouped into three per-
centiles. For a 4-symbol set, they're grouped into four 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 Format-
ting Icon Sets More Rules to display the New Formatting Rule dialog box. To modify an existing rule, choose
Home Styles Conditional Formatting Manage Rules. Then select the rule to modify and click the Edit Rule
button to display the Edit Formatting Rule dialog box.
Figure 19-10 shows how to modify the icon set rules such that only projects that are 100% completed get the
check mark icons. Projects that are 0% completed get the X icon. All other projects get no icon.
Figure 19-11 shows the project status list after making this change.
Search JabSto ::

Custom Search