Conditional Formatting: Microsoft Excel Add-In

Conditional formatting is used at the specified condition performance only. Conditional formatting makes data analysis more visual.

Conditional formatting can be applied to several table items and can consist of several conditions, for example:

Dimension item (row/column).
Entire table (data).
Column totals.
Row totals.

Settings of different conditional formatting types (color schemes, color scales, icons, histograms) overlap each other. If table elements have identical formatting type, settings are applied in the following order:

Entire table (data).
Dimension element.

Features of formatting application:

Conditional formatting of row totals (displayed in the column) is more important than column totals (displayed in the row).
If conditional formatting in the row overlaps the conditional formatting in the column, the conditional formatting by column is applied. This rule is applied equally to other table elements.
If several dimensions are located in heading or sidehead, for which conditional formatting is set, the higher importance is given to elements of the last dimension located in the heading or sidehead. This rule is applied equally to other table elements.

To set up conditional formatting, go to the Conditional Formatting tab on the side panel. The tab enables the user to create, edit, set up order or application of conditional formatting, and delete conditional formatting rules.

Select the table element, for which conditional formatting must be set up.
Go to the Table tab on the side panel.

NOTE. On selecting a table element the group of tabs in the side panel is renamed according to the selected element:
         ■   If heading or sidehead are selected - Format.
         ■   If data is selected - Table.
         ■   If totals are selected - Totals.
         ■   If all data cells are selected - Data.

Go to the Conditional Formatting tab.

The tab look depends on the type of conditional formatting rule to set up, for example:

Operations with Conditional Formatting Rules

To create a conditional formatting rule:

Select the table element, for which conditional formatting is set up.
Go to the Conditional Formatting tab on the side panel.
Click the Add button.

The tab displays parameters of created rule setup.

To edit a conditional formatting rule:

Select the table element, for which conditional formatting is set up.
Go to the Conditional Formatting tab on the side panel.
Select the required rule.

Rule parameters are displayed on the tab.

Formatting rules are applied as they are situated on the Conditional Formatting tab.

To reorder conditional formatting rules:

Select the table element, for which conditional formatting is set up.
Go to the Conditional Formatting tab on the side panel.
To move the selected rule:

Click the or button.
Select the Up or Down items in the rule's context menu.

To delete a conditional formatting rule:

Select the table element, for which conditional formatting is set up.
Go to the Conditional Formatting tab on the side panel.
To delete the selected condition:

Click the Remove button.
Select the Delete item in the rule's context menu.

A confirmation will be required.