Use conditional formatting on the sensor data tables to highlight cells or ranges of cells to help you visually detect critical issues and identify patterns and/or trends. Conditional formatting changes the appearance of cells based on conditions that you specify. If the criteria are met, the cell range is formatted; if the criteria are false, the cell range is not formatted.
At this time, conditional formatting does not apply to columns that have a score generated from a rule.
To apply conditional formatting to a data table:
-
From the Sensor or Score view, select the ellipsis icon in the column header.
-
Select Conditional Formatting.
-
In the Add Conditional Formatting window, complete the following:
-
Format cells that are:
-
Between
-
Equals
-
Greater Than
-
Less Than
-
-
Value: Enter the value for the criteria. The selection available relates to the data type displayed in the column. For example, for the Timestamp column, you will be selecting a date.
-
And: For a "Between" format, you will need to select the second value. For other operands, this field is not available.
-
With: Select the display format for the cells that meet the criteria.
-
Light Green Fill, Dark Green Text
-
Light Yellow Fill, Dark Yellow Text
-
Light Grey Fill, Dark Grey Text
-
Light Red Fill, Dark Red Text
-
-
-
To add additional conditions that need to be met, select the Add icon to the right of the first row.
-
Select Confirm to save the conditional formatting.