Apr 15 2021
I have a list to monitor staff training and when the training is due.
Managers enter the date their staff completes the training and it colour codes the cells based on when the training is completed, due and overdue.
The due date is 12 months or 24 months from the date they enter depending on the course.
So I have the following code
Completed - Green
Due 3 months (90 days) before due date - Orange
No date or not completed, not started or Overdue- Red
This works well and tested
I now want to add a either NA or change the text colour to green when the date 09/09/2099 is entered, as all the staff do not need that particular training. See below.