Conditional Formatting-Multiple Conditions

Copper Contributor

Column K has a rule to turn orange if date is great than 5 days.


Column L has a rule to turn red for cells that contain a blank value.


I need a formula for an additional condition if column L is not blank then column K goes back to white/no formatting.



1 Reply

@jzinn Add another rule to the column K, above the current one and check the box "Stop if true".



By the way, I'm wondering why to not just use =TODAY()-K2>5 for the other rule.