Jul 11 2023 07:53 PM
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.
Jul 11 2023 09:45 PM
@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.