Breadcrumbs

View/Edit existing conditional formatting


You can also choose Format→ Clear Formatting to remove all conditional formatting. However this will remove all formatting, including formatting that is not a result of Conditional formatting and revert to Excellentable defaults.


  1. Select the cell(s) where you want to find the existing conditional formatting rules.

  2. In the menu bar click Format → Conditional Formatting
    Capture 2019-10-02 at 17.40.36.png


  3. A menu bar will open on the right which shows the rules that apply to the cell(s). Click the x button if you do not want to edit.
    Capture 2019-10-02 at 17.44.10.png

  4. To add a new conditional formatting rule click "Add new rule".  To remove an existing rule, hover over the rule, and you will see a x button to delete the rule.
    image (3).png


  5. To edit a rule, click the rule you want to edit, and it will open the edit window. Make your changes and click "Edit Rule"
    Capture 2019-10-02 at 17.52.44.png


See Also:

Conditional Formatting in Excellentable