How do I edit a Conditional Format?

1. Click the Conditional Formats button on the toolbar.

Navigate to the system tools.

2. Select the Format that you wish to edit.


3. Edit the options.

Select the table you wish to edit and click to open the Table System Tool.

4. Click on the Filter(s) tab.

Filter(s) Tab

5. Edit the filters that controls the Conditional Format.

See What are the available filter types? for more on how filters work.

Select which Conditional Formatting you wish to edit.

6. Click Save.

Edit the Conditional and click Save.

7. Select it from the Active Conditionals drop down to make it active.

1. We can type the name of a Conditional Format(s), to help us find it (if there are a lot of saved Conditional Formats)...

2. By typing "View Watch" in the blank, it limits the visible Conditional Formats, so we can then click on the "View Watch" Conditional...

TMMData - - Google Chrome

1. We can see that the Conditional Format has been selected...

TMMData - - Google Chrome

8. Close the Conditional Formats modal.


9. Congratulations, you have edited a Conditional Format!