I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need it to highlight in red when it is 6 months before the due date in order to allow time to arrange the next course. Can anyone please help. The course was completed on 05/12/2017 and will be due on the 05/12/2019. so I need it to go red 6 months before 05/12/19.
Any help or advice would be greatly appreciated. Thanks in advance.