Configure rules for how numerical values are displayed in a multilevel pivot table
report, to easily highlight the more important values.
This task is part of configuring the style options of a multilevel pivot report.
On the Style tab of the report designer, click
Edit coloring rules.
In the Multilevel Pivot Rules dialog box, click New
In the New record dialog box, select an Operator.
Options are: greater than, greater than or is, lower than, lower than or is,
is, and between.
Specify a value. If you selected the operator between,
specify two values.
Select a font color and a background color.
Specify a Rule order.
If you do not specify a rule order, coloring rules are applied in the order in
which they were created.
Click Submit to save the rule and create a new rule, or
click OK to save the rule and return to the report