Conditional formatting on Grid works similarly to other widgets. You can define rules and apply specific formatting to a cell.
There is a separate formatting for text cells and bar/line cells. On bar/line cells, you can define a different set of rules and formatting for main value and benchmark.
The conditional formatting is applied to all of the cells in a dynamic row/column.
Rules that can be used in Conditional formatting:
Equals
Does not equal
Is less than
Is less than or equal
Is greater than
Is greater than or equal
Is empty
Is not empty
Contains
Does not contain
Starts with
Ends with
Custom condition
What is a Custom condition rule?
This rule allows the you to create your own conditions by using the expressions function (EXPR).
1. Select Conditional formatting and then choose Custom condition from the Rule list:
2. Next select EXPR - where you will be able to create your own expression based on the available syntax. Please see the Expression hints at the bottom of the Edit Expression modal for additional help.
3. Write your expression in the Edit expression modal as it is shown in the example below and press OK.
4. The created rule can be further adjusted by adding the required formatting such as font, background color, size etc.
5. Additional rules can be added here as well by using Add New feature.
