Category
Report Builder
Product Version
8.0
Conditional formatting with two possible outcomes?
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!
The same question
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:
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
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:
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
Replies have been locked on this page!