Forum Discussion
jzinn
Jul 12, 2023Copper Contributor
Conditional Formatting-Multiple Conditions
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 co...
Riny_van_Eekelen
Jul 12, 2023Platinum Contributor
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.