Create a new conditional style

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


  1. Click the object for which you want to define a conditional style and click the Conditional styles icon conditional styles icon.
    Tip: You can also click the object, and then, in the Properties pane, set the Conditional styles property.
  2. Click the add button add icon and click New Conditional Style.
  3. 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.

  4. In the Name box, type a name for the conditional style.
  5. To define a numeric value, date/time, date, time, or interval condition:
    • Click the new button new icon 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 edit icon 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 range bracket graphic to see the condition produced for that range.
    • To move a value above or below a threshold, click the arrow button move value above threshold icon 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.

  6. 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.