1. Right-click on the field
  2. Select Format Field to open the Format Editor window
  3. On the Border tab, click the X+2 button across from "Background"
  4. Enter the condition on which to change the background color of the field.

    For example: if {Gf_Amount} > 1000 then crRed else crWhite

    Note: if "else crWhite" is not included, the default background color will be black

  • Click Save and Close on the formula, then OK on the Format Editor window

If you would like to change the background color to red when there is no value in the field, a textbox is needed. Formatting does not display when the field is blank or null.
  1. Go to Insert > Text Object
  2. Place the textbox in the report
  3. Drag the field into the textbox
  4. Right-click on the textbox
  5. Select Format Text
  6. On the Border tab, click the X+2 button across from "Background"
  7. Enter the isNull() formula

    For example: if isNull({Gf_Amount}) then crRed else crWhite

    Note: if "else crWhite" is not included, the default background color will be black

  • Click Save and Close on the formula, then OK on the Format Editor window