Conditional Formatting

[SharonR]

I'm trying to get dates that are getting ready to expire in 10 days to turn
orange, then once the date has expired the date turns red. I've got the 2nd
criteria for the red text but can't get the formula to turn the date orange
10 days before expiry.....PLEASE HELP!!

 

[Tom Hutchins]

Assuming the dates are in column A, for the 10 days or less condition try
Formula Is
=(AND(A1-TODAY()<=10,A1-TODAY()>0))

Select A1, then select column A, then select Format >> Conditional
Formatting and set up your conditions & formatting.

Hope this helps,

Hutch

 

[SharonR]

Hi Tom

Unfortunately that didn't work. Any other suggestions?

Shar

 

[SharonR]

Hi Tom

Unfortunately this didn't work. Do you have any other suggestions?

FYI...I have to have 2 sets of criteria for the same column. One to turn
the date orange 10 days before expiry, and Two to have the date turn red once
the expiry is met.

Shar

 

[Tom Hutchins]

I didn't include the 2nd condition because your orignal post said you already
had that. Here is what I used for the 2nd condition (to turn expired dates
red):

Formula Is =(AND(A1-TODAY()<=0,LEN(A1)>0))

I'm sorry the formula I supplied didn't work for you. It (and the 2nd
condition above) work in my test workbook whether the dates are entered as
real Excel dates or as text. If you are sure you are applying the conditional
formatting correctly, then can you tell me anything else about your workbook
to help figure out why the formatting is not working correctly? Or, maybe an
MVP will have an insight for us.

Hutch