Apply a Formatting Rule Based on Multiple Matching Conditions
You can apply formatting to a cell or row where multiple conditions need to be matched. For example, you can highlight outage events in a New state where the number of customers off supply is more than 50 customers.
To do this, you need to create a rule, then in the Edit Rule dialog box, simply add two conditions:
Status is in NEW
#Out >=50