Defining Conditional Formatting

You can use conditional formatting to highlight important values or unexpected results in your data.

With conditional formatting, you define rules to select different or critical values in a crosstab. Results that fall outside a set of predetermined threshold values are highlighted in color or designated with symbols. This enables you to identify immediately any results that deviate from the expected results. For example, you directly see answers to questions, such as which products have over 10% revenue increase this year or which regions have sales volume higher than a defined amount.

You can add one or more rules to a conditional format and prioritize the application of the rules in your crosstab. You can also define more than one conditional format in a worksheet and decide for each of them when it should be active by toggling it on and off. Existing conditional formats can be edited or deleted.

Note The conditional formatting described in this guide is part of the Analysis Add-In. There is also a conditional formatting available in Microsoft Excel.