I would like cell B3 to turn blue if cell A3 is past a date and B3 is left blank. Can someone help me with a formula for that?
Also, is it possible to turn cell C3 blue when cell B3 is blue?
Thank you!
I would like cell B3 to turn blue if cell A3 is past a date and B3 is left blank. Can someone help me with a formula for that?
Also, is it possible to turn cell C3 blue when cell B3 is blue?
Thank you!
In CF use
=AND(A3>DATEVALUE("1/1/2012"),B3="")
format blue
Not without VBA, you might want to use underlying CF rules (if any) for Cell B3Also, is it possible to turn cell C3 blue when cell B3 is blue?
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you!!!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks