Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
2. Click the Home tab and choose Conditional Formatting ➜ Icon Set; then choose the most
appropriate icons for your situation.
In this example, the set with three arrows works (see Figure 4-27).
● The up arrow indicates an upward trend.
● A down arrow indicates a downward trend.
● A right-pointing arrow indicates a flat trend.
Figure 4-27: Your newly applied conditional formatting allows for a quick view of performance.
In most cases, you will want to adjust the thresholds that define what up, down, and flat
mean. Imagine that you need any variance above 3% to be tagged with an up arrow, any
variance below –3% to be tagged with a down arrow and all others to show flat.
3. Select the target range of cells; then click the Home tab and select Conditional
The Conditional Formatting Rules Manager dialog box opens.
4. Click the Edit Rule button.
The Edit Formatting Rule dialog box opens.
5. Adjust the properties, as shown in Figure 4-28.
6. Click OK to apply your changes.
In Figure 4-28, notice that the Type property for the formatting rule is set to Number
even though the data you’re working with (the variance) is in percentages. You’ll find
that working with the Number setting gives you more control and predictability when