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

Hi,

I have a list of employees who are required to resubmit an applicaiton for a room and board allowance every six months from their hire date. I am looking to have the cell with thier hire date turn red or alert me in some way when an employee is two weeks from their due date to resubmit, or 5 and a half months from their hire date/ last submission.

I have attempted to use the conditional formatting tool however the options are limited and I don't know which formula to use. Please help!

The data looks like this (attached)