conditional formating with dates

L

Lost Jason

Help

O.K. I have a list of dates. I need to format the colum cells with red,
yellow and green.
When an entered date is between today and 180 days ago the cell must be green.

When an entered date is between 181 days ago and 300 days ago the cell must
be yellow

When an entered date is between 301 day ago and 365 days ago the cell must
be red.

Any other entered date must be NO FILL.....

Please help me add these rules to me worksheet

Thanks,
Jason
 
B

Bob Umlas

Format/conditional formatting
Formula is:
=AND(TODAY()-A1>=301,TODAY()-A1<=365)
click Format, Patterns, then Red
click Add>>
Formula is:
=AND(TODAY()-A1>=181,TODAY()-A1<=300)
click Format, Patterns, then Yellow
click Add>>
Formula is:
=AND(TODAY()-A1>=1,TODAY()-A1<=180)
click Format, Patterns, then Green
 
Top