Conditional formatting in the Analysis 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. Analysis offers some simple pre-defined methods of conditionally formatting numeric data. Follow the directions below to implement conditional cell formatting.
1. Right-click a measure in the grid. Then select Conditional Formatting from the context menu. A sub-menu with conditional formatting types will appear.
2. Select your preferred number format from the list. Consult the table below for more information on simple conditional formatting types.
The Analysis report will refresh and apply the formatting choice you specified.