Conditional formatting items more than X number of days past due
Is there a way to set a rule for conditional formatting for rows where a due date is more than 45 days in the past?
Answers
-
Hi @Shannon Matter
Hope you are fine, you can create a helper column with the following formula
=TODAY() - [Due Date]@row
and create your conditional formatting rule using the helper column as reference. please check the following screenshot
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks. I was hoping to be able to do it without a helper column, but it appears that's not possible.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives