Apply conditional formatting to columns
Add colour automatically to column values based on the conditions you set for that column.
This feature is available from (shown in the image that follows):
The Data Viewer
The Column Format tab of the ribbon
The right-click menu of a column title
Formatting rules are applied in order, from top to bottom.
Conditional formatting is available in all grids.
Conditional formatting replaces any previously set colour formatting of a cell.
All applied conditional formatting is removed when closing a view or window.
Applied conditional formatting can be saved in a custom view.
How to add a conditional formatting rule
Click Add new to add a new rule. Rule categories depend on the type of column (they are the same as those for filters).
Set the colour for the rule with the colour selector. Use a preset option or a custom colour.
Rules are applied in the order they are added, from top to bottom.
How to edit conditional formatting rules
To edit a rule, click the pencil icon of the rule.
To change the colour, use the colour selector.
Remove rules in a category by clicking the trash icon next to the category.
Remove all rules by clicking the top right trash icon.
How remove conditional formatting rules
To remove specific rules, select them and click the trash icon.
To remove ALL rules, click ‘Clear all and close’.
