Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
If you would like more control over how the icons are assigned, choose Home
More Rules to display the New Formatting Rule dialog box.
Figure 19-11 shows how to modify the icon set rules such that only projects that are 100%
completed get check mark icons. Projects that are 0% completed get an X icon. All other projects get
Figure 19-11: Changing the icon assignment rule.
Figure 19-12 shows the task list after making this change.
Figure 19-12: Using a customized icon set to indicate the status of projects.