Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
As you can see in Figure 4-11, the result is a kind of heat-map within the cells you selected.
Figure 4-11: Conditional formatting with Color Scales.
Using icon sets
Icon sets are sets of symbols that are inserted in each cell you’re formatting. Excel determines which
symbol to use based on the value in each cell relative to other formatted cells.
To apply an icon set to a range, do the following:
1. Select the target range of cells to which you need to apply the conditional formatting.
2. Click the Home tab and choose Conditional Formatting➜Icon Sets.
As you can see in Figure 4-12, you can choose from a menu of icon sets varying in shape and
Figure 4-12: Applying icon sets.