Hello everybody I have the below problem if someone can help me:

we have a date in a cell let's say : 20/07/2014 (present day 16/05/14)

I need to add a conditional formating rule so when the present/real date will reach 15days before the 20/07/14 and until the speaking date the cell will be colored as notification to upcoming deadline (20/07/14)....

Meaning that the cell will be colored on 05/07/14 and 06/07/14....etc. until 20/07/14.

Thansk for your help in advance.!!!