Create a New Conditional Style

You can apply conditional styles based on any data item in your report.

Procedure

Click the object for which you want to define a conditional style and click the conditional styles button .
Tip: You can also right-click the object and click Style, Conditional Styles or click the object, and then, in the Properties pane, set the Conditional Styles property.
Click the add button and click New Conditional Style.
Select the data item to determine the condition and click OK.
The type of conditional style that you can use depends on the type of data item you select.
In the Name box, type a name for the conditional style.
To define a numeric value, date/time, date, time, or interval condition:
- Click the new button and select a value to define a threshold.
  The value appears in the Range column, and two ranges are created.
- For each range, under Style, click one of the predefined styles to apply to the range or click the edit button and create a new style.
  Tip: You can also define a style for the cells in your report that have missing values.
- Repeat these steps to add other conditions.
  Tip: Under Style, pause the pointer over each range to see the condition produced for that range.
- To move a value above or below a threshold, click the arrow button next to the value.
  For example, you insert a threshold value of five million. By default, the ranges are less than or equal to five million and greater than five million. Moving the five million value above the threshold changes the ranges to less than five million and greater than or equal to five million.
To define a string condition:
- Click the new button and select how to define the condition.
- To select more than one individual value, click Select Multiple Values and click the values.
- To type specific values, click Enter Values and type the values.
- To specify your own criteria, such as values that begin with the letter A, click Enter String Criteria and specify the condition.
- For each condition, under Style, click one of the predefined styles to apply or click the edit style button and create a new style. Specify the style to apply to remaining values by clicking one of the predefined styles beside Remaining values (including future values).
- Specify the order in which to evaluate the conditions.
  Conditions are evaluated from top to bottom, and the first condition that is met is applied.