Show TOC

To define a conditional formatLocate this document in the navigation structure

Procedure

  1. Choose Start of the navigation path Conditional Formatting Next navigation step New  End of the navigation path.
    The New Conditional Formatting dialog box appears.
  2. In the Name field, enter a name for the new conditional format.
  3. In the Based on list, select the measure you want to apply the conditional format to.
  4. In the Format list, select the style you want to use for highlighting values.
    The following styles are available:
    • Background: the cells background is colored.
    • Values: the text of the cells is colored.
    • Status Symbol: a symbol is displayed in the cells.
    • Trend Ascending: a colored arrow (green to red) is displayed in the cells.
    • Trend Descending: a colored arrow (red to green) is displayed in the cells.
    • Trend Grey: a grey arrow is displayed in the cells.
    Every style consists of nine members. The numbers 1 to 9 represent the priority of the rule.
  5. Define one or more rules on the Definition tab.
    1. Select the priority.
      In the first list, select one of the nine priorities of the style selected above. If you define more than one rule in a conditional format, and the rules overlap for values in your crosstab, the priority determines which rule is applied to these cells. You should therefore use a priority only for one rule in a conditional format. Priority one is the highest priority and priority 9 the lowest.
    2. Select an operator.
      You can choose one of the following operators: Between, Outside, Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To and Equal To.
    3. Enter a threshold value or value range.
    4. Press Add.
    The rule is added to the Rules area.
  6. Optional step: Define the selection for the conditional format.
    On the Selection tab, you can define for each dimension if the conditional formatting should be applied to All Members and Totals or only to the Members or Totals. The default value is All Members and Totals.
  7. Optional step: Define the visualization on the Display tab.
    Under Apply conditional formatting to:, you can define which parts of the crosstab are affected by conditional formatting: Data Cells, Row Headers and/or Column Headers.
    Under Apply Visualization to Another Measure:, you can specify that the conditional format defined for one measure (sales volume for example), is visualized in the data of another measure (sales order items for example). To use this function, select the Applied to check box.
  8. Press OK to apply your rules to the crosstab.

Results

You have created one or more conditional formats. They are saved with the workbook and are available to other users or in other sessions.