LinkBack URL
About LinkBacks
In column c I have a list of dates which i need to highlight 1 week before that date. take a look at my example.
FIWP Schedule Finish Dates.xls
In column c I have a list of dates which i need to highlight 1 week before that date. take a look at my example.
FIWP Schedule Finish Dates.xls
I'm not in 2003 and 2007 definitely works differently but select your range (e.g C5:C50), go to conditional formatting and select Formula =Does that work for you?
AND(ISNUMBER(C5),C5+7>=TODAY())
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
not working man.
=and(isnumber(c5),today()>=c5-7)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks