Highlighting Pivot Table metric values that fall within a specified range
The Conditional Formatting tab of the Pivot Table edit view allows you to highlight specific metric values.
To configure whether to use conditional formatting, and select the values to highlight:
To allow conditional formatting, make sure that the Enable conditional formatting check box is selected. It is selected by default.
If the check box is not selected, then there is no conditional formatting.
In the Metrics list, click the metric for which to configure conditional formatting.
For each metric, the list displays the number of conditional formatting rules created for it.
To add a new range of values to highlight for that metric, click +Add Condition.
To configure a condition:
From the Condition Rule type list, select the type of comparison.
In the field (or fields, for the between and a range from options), enter the value(s) against which to do the comparison.
Note that for the between option, the values are inclusive. So if you specify a range between 20 and 30, values of 20 and 30 also are highlighted.
From the Color list, select the color to use for the highlighting.
In the Tooltip Description field, type the text to display in the tooltip for a highlighted cell.
The conditions are applied based in the order they are listed. So a condition at the top of the list has a higher priority than a condition lower in the list.
To change the priority of the conditions, drag and drop them to the appropriate location in the list.
