Conditional formatting with two possible outcomes?

Paul shared this question 19 days ago
Answered

If I were to create two rules for a column, each one changing the cell color (say, one red and one green), but sometimes both rules would be true, how does it decide which one takes priority?


For example, a report that has a date column and a status column.

I want these to be red if the current date has passed the date inside the cell, and I want them to be green if the status is "completed".

If the date has passed AND the status is completed, would the cell be red or green? Is there a way to choose which it would be in case of a collision like that?

Sorry if I am not explaining well, thanks for your time!

Comments (1)

photo
1

Hi Paul,

I hope you're well. Yes, I follow what you mean. When creating a standard set of conditional formatting rules, the first rule takes priority if two conditions are true.

If you want to create a separate rule with two conditions joined by an AND operator, that's possible under an advanced conditional format rule.

See my example screenshot below:

/674b0007a2f82bd7851ac7ae46637740

So it requires a little extra setting up, but it is possible. You can even refer to both your date and status columns as part of the conditions. E.g. You could set the cell to be yellow in the case that the date has passed and the status is completed.

Kind regards,

Chris

photo
1

Thanks Chris, knowing that the 1st in the list takes priority and I can use multiple conditions will help a lot!

photo
1

No worries! Is there anything else I can help you with on this particular problem?

Kind regards,

Chris

photo
1

Hi Paul,

I haven't heard from you in some time, so I'm going to mark this as complete. But feel free to submit any additional questions as new tickets.

Kind regards,

Chris

photo