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

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!