Conditional formating using today() +/- 180 days

[Guest]

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.

 

[Guest]

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

condition 2: =A1>TODAY()+183
Format as red

 

[T. Valko]

Try this:

Condition 1 - Green
Formula Is:

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

Condition 2 - Red
Formula Is:

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

Biff