see conditional formatting - set up a formual comapring today() to the due date

"Kelly Lim" wrote:

Dear Excel users,
I have a spreadsheet containing names and dates......i would like to
know if there;s any formula for the below:

Let's say.......2 weeks before a due date....the cell with a name on it
will turn "orange" colour.....2 week after.... on the due date....the cell
will auto change to "red" colour.....
we would need this notification very urgently ......
Pls advice me....Thank you very much....