Conditional formatting based on date
Is there a way to highlight rows using Conditional Formatting when it's past a number of days?
Orange when it is 45 days after "Date of Visit"
Answers
-
Hi Stacey,
No. I would add another column and have it add 45 days from the date of visit and then do conditional formatting based on that. Does that make sense or would you like an example?
Chelsea
-
Hi Stacey,
You can do the following:
1) Add a Column called "45 Days After Visit" and make it a Date column in the column properties.
2) In the top cell of the "45 Days After Visit" column, enter this formula:
=[Date of Visit]@row + 45
3) Copy and paste the formula so it is in each row of the "45 Days After Visit Column"
4) Create the following Conditional Formatting rules:
Column "45 Days After Visit" "Is Today" and
Column "45 Days After Visit" "Is in the past"
Format: Orange background color for the Entire Row
5) Hide the "45 Days After Visit" column (optional step)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives