Microsoft Office Tutorials and References
In Depth Information
Using icon sets
FIGURE 19.19
Using an icon set to indicate the status of projects
If you would like more control over how the icons are assigned, choose
Home
More Rules to display the New
Formatting Rule dialog box. To modify an existing rule, choose Home Styles Conditional
Formatting
Styles
Conditional Formatting
Icon Sets
Manage Rules. Then select the rule to modify and click the Edit Rule button.
Figure 19.20 shows how to modify the icon set rules such that only projects that are
100 percent completed get the check mark icons. Projects that are 0 percent completed get
the X icon. All other projects get no icon. Click OK to apply the change.
FIGURE 19.20
Changing the icon assignment rule
19
Search JabSto ::




Custom Search