Conditional formating using today() +/- 180 days

M

mathew

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

Teethless mama

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

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

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
 
Top