I have a spreadsheet that contains a long series of dates in Column B. I need to know how to set Conditional Formatting so that if any date is 180 days before today, it turns green. If any date is 270 days before today it turns yellow, and if any date is more than 270 days before today, it turns red. I know this may be a simple question, but I'm stuck on this! Thanks in advance.
Last edited by NBVC; 03-02-2009 at 06:00 PM. Reason: Made title more descriptive
Invoke Format|Conditional formatting
Cell Value Is >> less than =Today()-270 click Format >> choose red
Click Add
Cell Value Is >> less than =Today()-180 >> click Format >> choose yellow
Click Add
Cell Value Is >> less than =Today() >> click Format >> choose Green
P.S. Please next time make title more descriptive.... See Forum Rules # 1
Last edited by NBVC; 03-02-2009 at 06:01 PM.
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.
Flagging cells by color based upon certain number of days
I have a similar situation. However, in the spreadsheet I've created I'm trying to flag cells by color based upon dates after an in date.
If the cell contains an in date and the current date is 10 days past that in date I want it to turn Yellow. 20 days past in date then Orange, and If 30 days past in date then Red.
Is there a way to even do that in Excel 03?
I do beleive with the help of what information you provided the other member with I am able to create a conditional format for entries I place in from here on out.
So what I figure it would be:
Cell Value is >> equal to = Today()+10 >> click format >> choose yellow
Click Add
Cell Value is >> equal to +Today()+20 >> click format >> choose orange
and then last condition would be today +30 and choose red
Is that correct?
It would be great if that's correct. The only thing is a format like that does not include the past in dates....like in dates from any date less than 8 Sep 11 and those would just have to be addressed manually.
I hope I've made some sense here in explaining this, and I hope I'm grasping the concept as least slightly =) any help would be greatly appreciated!
Welcome,
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks