Highlighting Results Table values that fall within a specified range

The Conditional Formatting tab of the Results Table edit view allows you to highlight specific numeric values in a Results Table.


Conditional formatting tab on the Results Table edit view

To configure whether to use conditional formatting, and to set the values to highlight:

  1. To allow conditional formatting, make sure that the Enable conditional formatting check box is selected.

    If the check box is not selected, then there is no conditional formatting.

  2. In the list, click the attribute or metric for which to configure conditional formatting.

    Only numeric attributes and metrics are included in the list.

    Each item in the list includes the number of conditional formatting rules configured for it.

  3. To add a new range of values to highlight for that attribute, click Add condition.
  4. To configure a condition:
    1. From the Condition Rule list, select the type of comparison.
    2. In the field (or fields, for the between or a range from options), enter the value(s) against which to do the comparison.

      Note that for the between option, the values are inclusive. So if you specify a range between 20 and 30, values of 20 and 30 also are highlighted.

    3. From the Color list, select the color to use for the highlighting.
    4. In the Tooltip Description field, type a brief description of the highlighting. The description is included in the tooltip for each highlighted cell.
  5. The conditions are applied based in the order they are listed. So a condition at the top of the list has a higher priority than a condition lower in the list.

    To change the priority of the conditions, drag and drop them to the appropriate location in the list.

  6. To remove a condition, click its delete icon.