Setting conditional formatting

Set conditional formatting so that specific information stands out when it meets the condition you specify.

To set conditional formatting:

  1. In the Tab Properties area, click Add Widget or on a table or KPI widget you want to change, click to open the widget menu and click Edit.
  2. For the table or KPI, click Edit Table Options or Edit KPI Options.
  3. For a table column, click on the column and set conditional formatting in the Properties box.

Conditional formatting options

  • Click the Foreground box and select a color for the text.

  • Click the Background box and select a color for the background.
  • In the Column drop-down, select a column.
  • In the Apply to Level drop-down, select a level to apply the conditional formatting (depends on the grouping applied).
  • In the Operator field, select an operator, if available (depends on the column's data type):
  • > (greater than)
  • >= (greater than or equal to)
  • < (less than)
  • <= (less than or equal to)
  • <> (not equal to)
  • Is One Of
  • Is Not One Of
  • Between
  • Contains
  • In the last field, enter a value. The value you enter depends on the Base. For example, enter a number for an amount Base but select a date for a date Base.
  • If you want to delete the condition, click X.