Excel 2007 : Conditional Formatting- A Date Occuring...

There are a couple options depending on your needs. The attachment assumes that the requirement is every 6 months based off of the hire date and NOT based off of the last date it was completed. So, if someone was late or early, it does not change the due date of the next requirement. Also, the conditional formatting alert will highlight the date 2 weeks in advance. It will automatically reset the day after the due date. If the alert should stay until it is complete, there will need to be a column added with some indicator that it is complete (i.e. the date of the last completion)and an edit to the conditional fomatting formula. See the attachment. Good luck!