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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives