Need Formula / Conditional formatting - Dates

[jeetusaini85]

Dear All,

I have a data file in which i have two column, 1st is Expiry Date column in which past, present and future dates are mentioned and 2nd is Status column in which user will mention status either "OK" or "Pending".

I need a formula / conditional formatting which will start highlight ( in Red Color ) Expiry date before 15 days of the Expiry Date till the user mark status as "OK" and change the color ( in Green Color ).

I tried many formula's and conditions but fails. Please help.

Thanks

 

[jeetusaini85]

Greatly thankful to you Joe, my query is sort out.

Many thanks to you for your guidance.....