Hello,
I know I have done this in the past, but now I am having trouble.
I have dates in cells that I want to do the following:
First Scenario:
If the date is today, change the color of the text
I have:
Cell Value is equal to =TODAY()
that is working fine
Second Scenario:
If the date is anything within 4 days before today, I want that to change.
I have:
Cell Value is Is Less than =Today()<4
that is not working
Third Scenario:
If the date has passed and less than 4 days before todays date, I want something to change.
I have:
Cell Value is Less than =TODAY()-4
But that is not working...
any help is greatly appreciated!
thanks!
Last edited by ibabs; 06-25-2009 at 02:43 PM.
See attached:
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
PERFECT!!!!!!!!
Thank you so much!!!
babs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks