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
A2 cannot be both OPEN and a DATE
=AND(A2="Open",B2<TODAY())
I assume it was a typo in the forum
try putting in a cell
=A2="Open"
and another Cell put
=B2<TODAY()
do you get TRUE or false for each of those
otherwise a sample sheet would help
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
Thanks for the reply.
I've done it in Column C. Now I'd like to highlight Column based if the text in Column C is true.
Hi,
Go to Conditional Formating->Manage Rules->New Rules->Use a Formula to Determine which cells to format.
You formula is correct so enter =AND(A1="Open",B1<TODAY()). Then OK and Then Apply.
Regards,
Thanks! worked when you did it.
does it work in your sheet now?
Yes all fixed. Thanks for your help.
your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks