Conditional formating using today() +/- 180 days

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
condition1: =AND(A1>=TODAY(),A1<=TODAY()+183)
Format as green

condition 2: =A1>TODAY()+183
Format as red
 
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
 
Back
Top