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"