adding a second condition to conditional formatting, both have to be true.

  • This formula works =AND(NOT(ISBLANK($K4)), ISBLANK($L4)), but I am not able to figure out where to put <> "TBD". I want L4 to fill with color if K4 is NOT blank & the entry in K4 <> TBD. I have searched & found dates, times, < & >. but nothing like what I am trying to accomplish. Is it possible. Thanks in advance.

  • isn't it?


    =AND(NOT(ISBLANK($K4)), $K4<>"TBD",ISBLANK($L4))

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!