Managing Conditional Highlighting for Table Values

Add Conditional Highlighting to Table Values

To specify conditional highlighting for values in a table, complete these steps:

Right-click in the table, and then select Conditional Highlighting to open the Conditional Highlighting dialog box.
Click New.

Three tabs appear in the Conditional Highlighting dialog box: Rule, Color and Font, and Image and Text.
On the Rule tab, complete these steps:
1. Select a Measure.
2. Select the Condition that you want the selected measure to match.
3. In the Value field, type in a value or select a measure in the drop-down list. If you selected Is between as the condition, then type a Min value and a Max value. If you selected Is missing value as the condition, then this field is unavailable.
  
  Note: If you are creating a condition for percentages, you must enter the conditional value as a decimal number. For example, if you want to filter for values above 50%, enter .5 as the conditional value.
  
  Rule Tab in the Conditional Highlighting Dialog Box for Tables is an example of the Conditional Highlighting dialog box that was used to create Total Sales Values That Are Greater Than $130,000 Are Highlighted.
  
  Rule Tab in the Conditional Highlighting Dialog Box for Tables
4. For multidimensional tables, the Rule Assignment option lets you specify which hierarchy level the rule will be applied to. You can specify one of the following:
  
  All hierarchy levels, which applies the rule to all hierarchy levels.
  
  Selected hierarchy levels, which applies the rule only to the hierarchy levels that you specify. Click Select. Select the specific hierarchy levels for the rule. Click OK.
  
  Selected Hierarchies in the Conditional Highlighting Dialog Box
(Optional) On the Color and Font tab, complete these steps to change the default settings:
1. Select the Font, including the font size and font color, that you want to use to highlight values that meet the specified condition.
2. Select the Font style that you want to use to highlight values that meet the specified condition.
  
  Color and Font Tab in the Conditional Highlighting Dialog Box for Tables
(Optional) On the Image and Text tab, complete these steps:
1. Select the Highlight by adding an image or text option.
2. Indicate whether you want to add an Image or Text when the specified conditions are met.
3. Specify a Position for the image or text. Indicate whether you want the image or text to appear to the right or left of each cell that contains a value that meets the condition or in place of the value.
4. If you are using an image, select the Image that you want to use to highlight values that meet the specified condition.
  
  Image and Text Tab in the Conditional Highlighting Dialog Box for Tables
5. If you are using text, type the text into the Text field, and then select the Font and font style information.
To hide the tabs, click OK.
To close the Conditional Highlighting dialog box, click OK.

Remove Conditional Highlighting from Table Values

To remove conditional highlighting from table values, complete these steps:

Right-click in the table, and then select Conditional Highlighting to open the Conditional Highlighting dialog box.
In the Rules list, select a rule.
Click Delete.
In the confirmation message box that appears, click OK to delete the rule.
Click OK.