Procedure
- Choose
.
The
New Conditional
Formatting dialog box appears.
- In the
Name field,
enter a name for the new conditional format.
- In the
Based on
list, select the measure you want to apply the conditional format to.
- 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.
- Define one or more rules on the
Definition
tab.
- 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.
- 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.
- Enter a threshold value or value
range.
- Press
Add.
The rule is
added to the Rules
area.
- 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.
- 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.
- 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.