Conditional Formatting Dates

I am trying to conditionally format dates that are in footers of grouped cells. The purpose is that I want to conditionally format dates in those cells that are 7, 14, and 30 days ago from today's date.
The context is that these days are our initial contact date. If we go 7 days without contact (changing the date to the current date) I want the cell to be pink, if we go 14 days from the initial date I want it to turn light red, and if we have gone 30 days without contact I want it to turn dark red.
Comments
-
Hello,
You'll want to use the "is in the next x days" or "is in the last x days" criteria in your conditional formatting rules.
More on conditional formatting rules can be found in the help center: https://help.smartsheet.com/articles/516359-conditional-formatting
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives