Forum Discussion

jzinn's avatar
jzinn
Copper Contributor
Jul 12, 2023

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 column L is not blank then column K goes back to white/no formatting.

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 12, 2023

    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.  

Resources