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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives