Show TOC

To edit conditional formatsLocate this document in the navigation structure

Context

Once you have defined conditional formats, you can open and change them, delete them or activate and deactivate them:

Procedure

  1. Choose Start of the navigation path Conditional Formatting  Next navigation step [Name of Conditional Formatting] End of the navigation path.
  2. Select one of the following options:
    • Select Edit if you want to change the current definitions of a conditional format. You can add new rules, change existing rules, , or delete existing ones.

      To change existing rules, select the Change icon in the rule that you want to change, change the definition of the rule and select the Apply icon to change the rule.

      To delete existing rules, select the Remove icon in the rule that you want to delete.

      To apply the changed rule(s) to your data, press OK.

    • Select Delete if you want to delete a conditional format.
    • Select or deselect Active if you want to toggle the formatting on and off.