Conditional Formatting
Hi
I have a sheet where the user would like to have rows highlighted in Red, Amber, Green based on when the last review date was completed:
Review in the last 10 months - Green
Review in last 11 months - Amber
Review in last 12 months (or more) - Red
I'm unsure the best way of doing this - do I need a formula in a helper column that I can look my conditional formatting rule up to, do I do a report that groups by months?
Any ideas greatly received on the best way to achieve getting this information.
Many thanks
Cheryl
Best Answer
-
Try changing it to "is in the past".
Answers
-
You should be able to do this directly in conditional formatting as long as you stack the rules in the proper order (it will highlight the color based on the first true rule starting from top to bottom).
Select your date column and set it to be when the date is in the last 305 days for Green.
The next one down would be 335 days for Amber.
The third one down would be 365 days for Red.
-
Thanks for responding. I have added the conditional formatting as per your suggestion however, my red rule doesn't appear to be working unless it's bang on 365 it needs to be 365 or more?
-
Try changing it to "is in the past".
-
Hi @Paul Newcome That's done it - thanks
-
Excellent! Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 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
Check out the Formula Handbook template!