change cell color when exp date is within 3 weeks

Options

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!

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    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.


Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    AveryH ✭✭
    Options

    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!