Formatting columns conditionally

You can format column headings and fields to highlight data that meets specific criteria. For example, if you want to emphasize fields for users with a high number of login failures, you can apply text and background formatting to those users.

About this task

If multiple conditions are applied to a single field, their order affects how they function. Conditions are read and applied from bottom to top, and the topmost condition overrides any condition lower in the hierarchy.

Because conditions higher up in the hierarchy can affect conditions below, the font style selection buttons each have three states:
  • Unchanged, inherits the previous condition-based style, if any.
  • Set, the style is applied to text that meets the condition.
  • Not set, the style is not applied to the text that meets the condition, and is removed if a conflicting condition lower in the formatting hierarchy marked that style as Set.
The background and font color pickers have buttons for similar states.
  • Unchanged, inherits the previous condition-based color, if any.
  • Set, the color is applied to text or background of the field that meets the condition.
  • No fill (background only), no color is applied to the background that meets the condition. Regardless of conditions lower in the hierarchy, the background inherits the default color.

Procedure

  1. Run the report.
  2. Click the column header of the column that you want to format.
  3. Hover over the Column Options Column Options icon and select Formatting. Click the Conditional Formatting tab.
  4. In the Apply to box, select the part of the column you want to apply the formatting to.
  5. Click Add to add a condition to the Conditions List.
    • Operator. Select an operator to define how the condition is compared to the column data.
    • Condition. Enter the condition criteria.
    • Format. Select the formatting to be applied to fields that meet the defined condition.
  6. Click OK to apply the condition to the column.