Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
The words Sales_Amount and Market are not permanent fixtures of the New Formatting
Rule dialog box. These words change to reflect the fields in your pivot table. Sales_
Amount is used because your cursor is in that column. Market is used because the active
data items in the pivot table are in the Market field.
In this example, the third selection (All cells showing Sales_Amount values for Market) makes
the most sense, so click that radio button, as demonstrated in Figure 15-15.
Figure 15-15: Click the radio button next to All cells showing “Sales_Amount” values for “Market”.
2. In the Select a Rule Type section, you need to specify the rule type you want to use for the
You can select one of five rule types:
Format All Cells Based on Their Values: This selection allows you to apply conditional
formatting based on some comparison of the actual values of the selected range. That is,
the values in the selected range are measured against each other. This selection is ideal
when you want to identify general anomalies in your dataset.
Format Only Cells That Contain: This selection allows you to apply conditional formatting
to those cells that meet specific criteria you define. Keep in mind that the values in your
range aren’t measured against each other when you use this rule type. This selection is
useful when you’re comparing your values against a predefined benchmark.
Format Only Top or Bottom Ranked Values: This selection allows you to apply conditional
formatting to those cells that are ranked in the top or bottom nth number or percent of
all the values in the range.
Format Only Values That Are Above or Below the Average: This selection allows you to
apply conditional formatting to those values that are mathematically above or below the
average of all values in the selected range.