Conditional formating using today() +/- 180 days
 

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.

Conditional formating using today() +/- 180 days
 

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.

Conditional formating using today() +/- 180 days
 

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.

Conditional formating using today() +/- 180 days
 

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.