This is really dumb- especially since I've spend a amount of time searching on this, so any help is greatly appreciated.
I have a spreadsheet as follows:
A1 = Open or Closed
B1= A date
I would like to highlight B1 based on the following conditions:
1) A1 = Open
2) B1 < Today
Here's what I've tried but with no success:
=AND(A2="Open",A2<TODAY())
Thanks
Bookmarks