Manage Conditions

Manage all the conditional formatting defined in the spreadsheet.

To access this command...

From the menu bar:

Choose Format - Conditional - Manage

From the tabbed interface:

Choose Home - Conditional - Manage.

The Manage Conditional Formatting dialog is where you can add, edit or delete one or several conditional formattings.

The Conditional Formats list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.

If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range).

Please support us!