Conditional Styles allow you to create rules that decide how columns and rows are styled.
Rules work at either column or row level; when the rule is met the column / row is styled according to the style set out in the rule. Alternatively you can specify a css style name (which you provide).
This example has 4 Conditional Styles:
- The 'Change Last Order' column has 2 styles: it is green when positive and red when negative;
- Any row where the 'Item Cost' column is more than 80 is italicised with a yellow background (note thatExcludeGroupedRows is true so the style is not applied on grouped rows.)
- The font is bold where the 'Package Cost' column is less than 10