Hi Tom

Unfortunately that didn't work. Any other suggestions?

Shar

"Tom Hutchins" wrote:

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" wrote:

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!!