Conditional Formatting-Multiple Conditions

Copper Contributor

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

jzinn_0-1689130171251.png

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

jzinn_1-1689130230989.png

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

jzinn_2-1689130380588.png

 

1 Reply

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

=ISBLANK(L2)

 

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