Conditional formatting with two possible outcomes?
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!