Conditional Formatting

The Conditional Formatting tab is used to set up advanced cell formatting dependent on the specified condition.

Conditional formatting makes data analysis more visual.

NOTE. Conditional formatting overlaps the formatting of the specified table style but it does not overlap the cell formatting settings interface. First, cell formatting settings are applied and then conditional formatting is used.

The tab looks as follows:

Add new condition to list

Edit selected condition

Delete selected condition

See also:

Working with Formatting Dialog Box