Hello Everyone,
I hope you can help me. I been wracking my brain trying to get this working but have hit a brick wall.
My problem is as follows. (I will try to keep it simple)
I have a date in Cell A1 (Target Date) where i need to recieve 2 documents
Cell A2 is for the date i recieve Document 1
Cell A3 is for the date i recieve Document 2
I want cell A1 to highlight yellow if it is due to expire in less than 5 days
I want cell A1 to highlight red if the date has expired
Now the issue i have is getting Cell A1 to remain "Unformatted" if the dates in A2 & A3 are less than the target date (Cell A1)
At the moment when the date expires it goes red even if the target is met in Cell A2 & A3.
PLEASE HELP!!!!!
Bookmarks