change cell color when exp date is within 3 weeks

AveryH

Hello, I would like to change the color of cells in a column to yellow when the expiration date is within 3 weeks, and to red when the exp date is that day and beyond. I was able set a rule for the red (exp date is in the past and also exp date is today) but cannot figure out how to set the 3-week warning. Thanks!

KPH

Hi @AveryH

When you set up your conditional formatting and choose "Define Custom Criteria" there is an option to specify "is in the next (days). If you set this to 21 days, it will apply your formatting for dates that are in the next 3 weeks.

KPH

Hi @AveryH

When you set up your conditional formatting and choose "Define Custom Criteria" there is an option to specify "is in the next (days). If you set this to 21 days, it will apply your formatting for dates that are in the next 3 weeks.

AveryH

I thought I had tried that yesterday, and maybe I had, but I think my test date is where I failed -- I went the wrong way. Thanks so much!