Hi!

Assume cell A1 contains the name and cell B1 contains the due date.

Select cell A1
Goto FormatConditional Formatting
Condition 1
From the drop down select Formula Is
In the box to the right enter this formula: =AND(B1<"",B1<=TODAY())
Click the Format button
Set the fill color to RED
Click OK

Click the Add button

Condition 2
Formula IS: =AND(B1<"",B1-14<=TODAY())
Click the Format button
Set the fill color to orange
OK out

14 days from the due date cell A1 will turn orange and stay orange until the
due date. On the due date cell A1 will turn red and stay that way.

Biff

"Kelly Lim" wrote in message
...
Sorry....im not expert in Excel....so would you mind teaching me step by
step
in the formula?? please....

....