change cell color when exp date is within 3 weeks
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
-
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
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 447 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!