Highlighting Values

To open the Highlight values dialog, do one of the following:

• Click Table options > Highlight values
• Select View menu > Table options > Highlight values

Highlighting values assigns colors to selected ranges of data values. You can choose up to five ranges for each measure.

To highlight values:

1. Choose a measure from the drop-down list.
2. Select a cell color row . Enter the low value of the range that you want to appear colored in From, and the high value in To, and then click OK. (You can also accept the preassigned values "min" or "max" as the low or high values. If you accept min and max for both values, all cells for the selected measure will appear in the chosen color.)
3. To clear a range, click the Clear button .
4. To select or clear all the ranges at once, you can click the Select all exceptions for this measure button or the Clear all exceptions for this measure button.
5. If you wish, you can click the Cell Color and Text Color browse buttons and choose different colors for a range. A palette of 64 standard "web-safe" colors is provided. Colors appear in the Preview cell, along with their hexadecimal color values.

Notes:

• Value highlighting colors override any cell colors that may have been defined in the cube at the time it was created.
• Value highlighting is based on the original cell values before scaling is applied. Therefore cell colors will not change if different scaling factors are applied.
• Cell colors do not appear for cells that contain percentages or calculated values.
• It is possible for ranges to overlap. Values that fall into two or more overlapping ranges take the color of the last range they belong to, as shown in the value highlighting list.
• Colors do not appear in charts.