Creating a conditional formatting rule

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.
  1. Select the Create new conditional formatting rule icon.
  2. 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.
  3. 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.
  4. Select an operator, and enter one or more values for the condition.
  5. Select Format, choose the appearance of cells that meet the condition, and select OK.
  6. 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.