Highlight values dialog

Highlighting values assigns colours to selected ranges of data values. You can choose up to five ranges from 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 value. 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 use Select or Clear all exceptions for this measure. ( - selects and - clears.)
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.
• Value highlighting is an optional feature which may not be enabled for all Perspective sites.