Conditional formatting with dates
Erica Cole
✭✭✭✭
I want to add conditional formatting that is triggered if a date is more than 2 days old. Which of these criteria should I select? Is this possible?
Tags:
Answers
-
Hi @Erica Cole,
to do that you need to add a helper column call it "Remaining Time" for example and use the following formula in this column and convert it to column format formula:
=TODAY() - [Submittal Date]@row
then in conditional formatting use this condition ( "Remaining Time" is less than -2 )
here is a screenshot shows the result
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"
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives