By default, new conditional formatting rules have higher priority than older rules.
Before you can define a conditional formatting rule, a table must have a measure added to
it.
- Select the Create new conditional formatting rule
icon.
- In the Rule Editor dialog, enter a name for the rule.
If you do not enter a name, the rule will be named automatically, based on the condition
that you set.
- In the Based On list, select a measure.
This measure determines the values that are used in the rule and the column where
formatting appears.
- Select an operator, and enter one or more values for the condition.
- Select Format, choose the appearance of cells that meet the
condition, and select OK.
- In the Rule Editor dialog, select OK.
The conditional formatting rule is applied to the table.
If needed, you can use the Rules Manager dialog to change
the priority of rules.