Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
To start creating your first custom formatting rule, open the Chapter 4 Samples.xlsx file found in the
sample files for this topic. With the file open, go to the Create Rule by Hand tab.
1. Select the target range of cells to which you need to apply the conditional formatting and
select New Rule as, shown in Figure 4-15.
Figure 4-15: Select the target range; then select New Rule.
The New Formatting Rule dialog box opens, as shown in Figure 4-16.
As you can see, some of the rule types at the top of the dialog box are predefined option
choices discussed earlier in this chapter:
Format All Cells Based on Their Values: Measures the values in the selected range
against each other.
This selection is handy for finding general anomalies in your dataset.
Format Only Cells That Contain: Applies conditional formatting to those cells that meet
specific criteria you define.
This selection is perfect for comparing values against a defined benchmark.
Format Only Top or Bottom Ranked Values: Applies conditional formatting to those
cells that are ranked in the top or bottom nth number or percent of all the values in the
Format Only Values That Are Above or Below the Average: Applies conditional
formatting to those values that are mathematically above or below the average of all values
in the selected range.
Format Only Unique or Duplicate Values: Applies conditional formatting to cells that
either contain values that are duplicated within the selected range or contain values are
unique (not duplicated) within the selected range.