Creating a formula condition

To create a formula condition:

  1. Right-click the cell in which to create the condition and select Formula is in the Condition field.
  2. Specify the formula in the adjacent field.
    Note: Do not prefix the formula with the equals sign (=).

    Formulas can contain references to report objects and their properties.

    SeeInserting list objects.

  3. Click Add
    The condition is added to the List of conditions.
  4. To assign a predefined format to the condition, select a format from the list.
  5. To specify a format for the condition, select Format in the list and click Edit Entry Format.
    The Edit Format dialog box is displayed.
  6. Specify the format to apply.
    The Edit Format dialog box operates in the same way as the Format Cells dialog box.

    See Formatting cells

    Note: If you change a condition, click Apply to apply your changes.
Parent topic: Specifying conditional formatting