Forum Discussion
Laura87
Dec 22, 2023Copper Contributor
Conditional formatting - highlight dates due in 90 days not working
I have a training matrix setup which records training expiry dates, I have used conditional formatting to highlight cells which
- Are blank - training to be completed (yellow)
- Contain N/A (grey)
- Expiry is greater than todays date (green)
- Expiry is within 90 days of todays date (orange)
- Expiry is less than todays date (Red)
The formatting for 'due within 90 days' is not working, what do I need to fix?
2 Replies
- OliverScheurichGold Contributor
- Laura87Copper ContributorThanks. That doesn't work either 😔