Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
This rule was designed more for data cleanup than for dashboarding, enabling you to
quickly identify duplicates and unique values in your dataset.
Here’s a simple example of how to apply one of these options. To highlight all values greater than a
certain amount, follow these steps:
1. Select the range of cells to which you need to apply the conditional formatting.
2. In the Highlight Cells Rules category, choose the Greater Than option (see Figure 4-2).
The Greater Than dialog box opens, as shown in Figure 4-3. The idea here is to define a value
that will trigger the conditional formatting. You can either
● Type the value (400 in this example).
● Reference a cell that contains the trigger value.
Also in this dialog box, you can use the drop-down menu to specify the format you want
Figure 4-3: Each option has its own dialog box that you can use to define the trigger values and the
format for each rule.
3. Click OK.
You immediately see the formatting rule applied to the selected cells (see Figure 4-4).
Figure 4-4: Cells greater than 400 are formatted.