Hello!
I would like cell A1 to turn blue if cell A2 is now and cell A3 and/or A4 are left blank.
Is that possible?
Hello!
I would like cell A1 to turn blue if cell A2 is now and cell A3 and/or A4 are left blank.
Is that possible?
Use the following (if you really meant NOW()) for the conditional formatting on cell A1 (see attached)
=AND($A$2=NOW(),OR($A$3="",$A$4=""))
Last edited by GeneralDisarray; 06-18-2013 at 01:20 PM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Sure! Thank you.
if cell A2 is 6/18/13 (or passed that date).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks