On May 19, 5:48*pm, jstegall
wrote:
I have a range of dates "=$B$2:$Q$41" that I need to have the cells change to
green if the date is less than 6 months old, yellow if between 6 months and
360 days, and red if anything older than 360 days. *I appreciate any help I
can get. *I am using Excel 2007.

I am not sure how much different 2007 is from 2003 so II will throw
out this soloution and hope it helps you out. Highlight cells that
you want to change color. Click format cells\Conditional Formatting.
Chose by formula and not by cell. This is the formula that you woudl
put in if N8 was the celll that contained the date =(TODAY()-N8)<180.
Then you just have to add additional formatting and change the 180 to
360 and then to 360 to go red.

I hope this helps,
Jay