Excel 2007 : Conditional Formatting- Mixed Data

Hi,

I have a list of data with various dates and the occasional blank or N/A. Is it possible to have a formula alert me when a date is within two weeks of today's date (in the future) that turns off when another cell has a value of approved?

My issue is that when I use a conditional formatting formula like =(A2-14)<TODAY() the cell alerts dont go away.

Thanks for the help!

See attached data