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.

condition1: =AND(A1=TODAY(),A1<=TODAY()+183)
Format as green

condition 2: =A1TODAY()+183
Format as red


"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.

Try this:

Condition 1 - Green
Formula Is:

=AND(A1=TODAY(),A1<=TODAY()+183)

Condition 2 - Red
Formula Is:

=AND(ISNUMBER(A1),OR(A1<TODAY(),A1TODAY()+183))

Biff

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

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.