Managing conditional formatting rules

Use the Rules Manager dialog to edit, add or remove, turn on or off, and set the priority order of rules.

Before you can manage conditional formatting rules, a table must have a measure added to it.
  1. Select the arrow beside the Create new conditional formatting rule icon, and select Manage Rules.
  2. In the Rules Manager dialog, perform any of these actions:
    Option Description
    To create a rule Select the icon.
    To delete a rule Select the - icon.
    To modify a rule Select a rule and select Edit Rule.
    To disable a rule Clear the check box in the Applied column next to the rule name. Disabled rules are not applied to the table, but you can turn them on again if necessary.
    To change the priority of a rule

    Select a rule and use the Change Rule Order icons to move it higher or lower in the list.

  3. Select OK.