Conditional Style Advanced Rule Demo

For more complicated Conditional Styles there is the option to use a Query when creating the Conditional Style Rule.

This will enable evaluation across multiple columns using more advanced criteria.

When the rule is met the column / row will be styled according to the style properties provided.

This example has 2 Conditional Styles that provide a Query (and have a Scope of 'All: true'):

  • Whole row is gray where 'InvoicedCost' column value is over 1000
  • Whole row is yellow where 'Employee' column value is either "Michael Suyama" or "Janet Leverling"

Generating dummy data, please wait ...