Manage Conditional Format

You can update criteria, change priority, disable, or delete conditional format rules. Open Conditional Format Manager in the Tools > System menu.

Change priority

In the Priority column, drag the rule to the desired position or click the Actions menu in the rule row and select Move to bottom or Move to top.

Update a format

Edit a conditional formatting rule and control whether it is enabled.

1. Click the Actions menu in the rule row.

2. Select Update.

3. Change the rule name, select a different style, or change the rule criteria.

4. To disable the rule, turn off the Enabled toggle.

5. Click Update to save.

Enable a format

When you create a new conditional format, the rule enables automatically. If you manually disable a rule, it appears after the enabled list without a priority number. To reactivate a rule:

1. Click the Actions menu in the rule row.

2. Select Update.

3. In the Update format dialog, select Enabled.

Delete a format

1. Click the Actions menu in the rule row.

2. Click Delete.

3. In the confirmation dialog, click Delete.