Creating a formula condition

  1. Right-click the cell in which to create the condition and select Conditional Formatting. Then 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.

  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 the Edit Entry Format icon.
    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.
    Note: If you change a condition, click Apply to apply your changes.