Conditional Styles allow you to create rules that decide how columns and rows are styled.
The Scope of the style determines where it can be applied: ie. whole row, one or more columns, or one or more column data types.
The Rule of the Style determnines if the style should be applied; when the rule is met the column / row will be styled according to the style properties provided.
Typically the Rule for the Conditional Style is based on a Predicate - only the Predicates associated with the selected scope are available.
This example has 3 Conditional Styles that use Predicates:
- All colunns of DataType: Number have a green font when they are positive (using the 'Positive' predicate)
- All colunns of DataType: Number have a red font when they are negative (using the 'Negative' predicate)
- 'Item Cost' column is italicised with a yellow background where it is greater than 60 (using the 'GreaterThan' predicate)