Conditional Formatting

Grid cells can be formatted with color and text style based on data conditions.

Access Conditional Formatting

For this, click Template under Column Settings :

In the Edit Columns Template dialog, select on the left a a column where you want to apply a formatting, then select Conditional Formatting and click Edit :

Add a Condition

In the Grid Conditional Formatting dialog, click + to add a first Condition :

Configure a Condition

A new Grid Conditional Formatting dialog appears for this new Condition :

Based On column

The Based On column selector allows to select which column will be used to calculate the condition :

*Hint :
A Condition can be based on a different column than the one the formatting is applied to.
It can also be based on a Hidden Column. This allows to base the condition on a complex Expression, but not show it to the end user.

Color Settings

Two color modes are possible :

• Single Color : based on a boolean condition, a single color is wholly applied or not, depending if the row meets the condition
• Gradient : based on a numerical field, a color gradient is applied to all cells, with color intensity depending on the magnitude of the number

Formatting Type

The formatting can be applied either :

• Column : on the cells of the selected column only
• Row : on all the cells of the same row
  

Single Color : Condition

For Single Color mode, the boolean condition is configured as : Column Operator Value
Example : AlarmLevel >= 100

The operator can be selected from the Condition combobox :

The value to compare to can be entered in the text field called Values or a Dashboard Parameter can be used instead :

Single Color : Style

For Single Color mode, the style applied includes font color and style (Bold, Italic, Underlined, Stricken) :

Gradient : Style

For Gradient color mode, the style applied includes font color and gradient color :

Condition Order

Conditions will be applied in the same order as the list of conditions.

Example

The following list of conditions will apply the widest condition last (>1M), which will override any formatting done in the previous narrower condition (>10M) :

In order to apply a different color to the narrower condition (>10M), it needs to be listed last :

Editing a Condition

Click on a Condition and click on the pen icon to edit :

Deleting a Condition

Click on a Condition and click on the trash icon to delete :

Code192 2020 All rights reserved