Simple Conditional Formatting of Measures
Conditional formatting in the Analyzer data grid means that cells will be physically affected by the data they contain. The most common form of conditional formatting is stoplight reporting, where cell backgrounds are colored red, green, or yellow depending on user-defined thresholds. Analyzer offers some simple pre-defined methods of conditionally formatting numeric data. Follow the directions below to implement conditional cell formatting.
Right-click a measure in the grid, then select Conditional Formatting from the context menu. A sub-menu with conditional formatting types will appear.
Select your preferred number format from the list.
The analyzer report will refresh and apply the formatting choice you specified.
Conditional Formatting Types
Indicator Type | Description |
|---|---|
Color scale | The background cell color will be shaded according to the value of the cell relative to the highest and lowest recorded values in that measure. There are several color progressions to choose from. |
Data bar | The cell background is partially filled with a solid color proportional to the scale of the cell's value relative to the highest and lowest recorded values in that measure. |
Trend arrow | An upward or downward arrow is displayed to the right of the cell value depending on whether it contains a positive or negative value. |