maybe i am confused
lets say your cell with a date is on A1. Place a red color cell background.

then place your desired reference date [as your constant ref] for your
today() on B1

on A1 - conditional format
formula is =AND(A1=B1,A1<=B1+183)
-------[180 or 183 or whatever +constant u wish]
select green color as pattern

regards
driller
--
*****
birds of the same feather flock together..



"mathew" wrote:

I have a date in A1. For example today's date 1/11/07. Using conditional
formating is there any way to have the cell; be green for today's date
through 183 days later then be red for any other day that does not meet this
condition? Thank you in advance for your help.