Creating a Condition

In order to get started with conditional formatting, text and/or conditional suppression, you first define the condition on the Conditional Properties panel. For more information about the criteria and parameters available for each conditional format or suppression type, see Conditional Formatting, Text and Suppression Criteria and Parameters.

Note:

When defining a condition that tests for data values, for example, Cell Value, Row Value, Column Value or Current Cell Value, in Table Properties, you specify if conditional formatting and suppression uses scaled or unscaled raw data values within a condition using the table property Use scaled/rounded value.

• The default is True, which means that the formatted and scaled data values are used within the condition. For example, if a cell with a data value of "125,016,551" is scaled to thousands and displays as "125,016", the "125,016" value will be used within the condition.

• If the property is set to False, the underlying and unscaled data value will be used within the condition. This setting applies to all conditional formatting and suppression for the table.

To define a condition:

1. Select the area of the table that you want to add a conditional format (cells, rows, or columns) or conditional suppression (rows or columns) to.

2. In Table Properties, click .

3. Perform an action:

   • To create a conditional format and/or text, click Formats/Text, and then click

   • To create a conditional suppression, click Suppressions, and then click .

4. Enter a descriptive name for the conditional format/text or suppression in the Name field. The name must be unique for the table.

   Note:

   You do not need to enter anything in the Applies To field. After you create the condition, the Applies To field will list the areas of the table that you identified in step 1. You can modify the values in the Applies To field to change the area of the table that you want the condition to apply to.

5. In the expression builder, click Attribute and select an attribute that you want to test for. For example, you can test on the current cell value or an attribute value.

   After you selected an Attribute, the Qualifier and Operator fields will change to reflect the available parameters.

6. If applicable, specify a Qualifier. For example, if you selected Attribute Value for the type, then you enter the name of the attribute value that you want to test for as the qualifier.

7. Select an Operator.

   • For numerical conditions (data values), use a numerical operator (equal to, not equal to, greater than, less than, and so on.).

   • For textual conditions (for example, Attribute Value) use a textual operator (starts with, ends with, and so on).

8. Select or enter a Right Qualifier, which is the condition that you are testing for.

   • For numeric qualifiers, you can use delimiters and the negative sign (-). All other prefixes and suffixes are ignored.

   • For textual qualifiers (such as Attribute Value), manually enter the text string that you want to test for.

     Note:

     Member Selector is not available in the expression builder.

9. Optional: Click to insert additional expression condition rows.

   Use AND or OR to combine or differentiate the conditions. For example, you can create a condition that tests for data values greater than or equal to 100 AND less than or equal to 1000.

   Click to remove an expression condition row.

10. Formatting/Text Only: In the right panel:

    • In the Format tab, specify the format (for example, font size, border, and shading) for the condition. Click # to open the number formatting menu.

      Note:

      In the conditional formatting panel, if any format fields are not changed or defined (for example, font styles, number formatting, and so on), the affected table cells will use the cell formatting defined in the Table Cell properties for the undefined fields and not the undefined field in conditional formatting. For example, in conditional formatting, under number formatting, if a negative prefix and suffix are not changed or defined, the affected table cell will use the negative prefix and suffix defined in the Table Cell properties.

    • In the Text tab, define the text to display. You can manually enter static and insert one or more text functions using the button. You can also format the text using , which formats all the returned text, as text cells cannot display mixed formatted content, only one format can be applied to all the text.

    Note:

    Regarding formatting for Conditional Text:

    If the ConditionalText function is inserted into a table cell, the formatting defined for the Conditional Text will always override the cell formatting in the table or report output.

    If the ConditionalText function is inserted into a text box:

    • In the Conditional Text Format dialog, if Use Default is not selected and a format is defined, even if formatting is defined for the ConditionalText function in the text box, the formatting defined for the Conditional Text will override the text box formatting in the report output.

    • In the Conditional Text Format dialog, if Use Default is selected, and formatting is defined for the ConditionalText function in the text box, the text box formatting will be used in the report output.

    The format and/or text that you specify is displayed in the sample at the top of the Conditional Formats/Text panel.

11. Optional: Select (or multi-select) an expression condition row, and then right-click or select to group, remove, duplicate, or move them up or down.

    For more information on grouping expressions, see Working with Advanced Conditions.

12. Click OK to save the condition.

    The condition is displayed in the Conditional Properties panel. For formats, the sample formatting is also displayed, for text, a portion of the text definition is displayed.