Conditional Formatting

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 on the basis of 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. 

To apply conditional formatting to a data table:

1. From the Sensor or Score view, select the ellipsis icon in the column header.
2. Select Conditional Formatting.
3. 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
4. To add additional conditions that need to be met, select the Add icon to the right of the first row.
5. Select Confirm to save the conditional formatting.