The color option enables you to highlight rows with different colors based on some condition. You can use multiple conditions and group them using And/ Or.

When you use “And” to group conditions, then the entries that are true for both the conditions will be highlighted.

When you use “Or” to group conditions, then the entries that are true for both or any one of the conditions will be highlighted.

For example you can add a condition to highlight all the entries in which the city is New York in blue color. Then you can add another condition to highlight all the entries in which the designation is manager. If you use the “And” operator to add the second condition, all the entries whose city is New York and designation is manager will be highlighted in blue. If you use the “Or” operator to add the second condition, all the entries whose city is New York and all the entries whose designation is manager( even if the city is not New York) will be highlighted in blue.

Using AND operator

Using OR operator

To add a color, click on the Color option in the top bar and a drop down will appear. You can then add the columns operator and value to set the condition.

You can read about the different operators you can use with each column type here.

Did this answer your question?