Tom Carron
New Member
- Joined
- Dec 16, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a list of dates that training was completed (so these are dates in the past), and this particular training should be refreshed every 12 months. What I'd like to know is can I use conditional formatting to change the colour of the date (to orange for example) 11 months after the training date to remind that it is coming up to refresh time, and then to red 12 months after the training date to show that a refresh is overdue?