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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!