conditional formating with dates
 

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

conditional formating with dates
 

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

"Lost Jason" <Lost wrote in message
...
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