Getting a fill color on a certain date

[Eric]

How can I get a cell to display a fill color on a date -10 days and then
another color on that date.

For example, I'm creating a spreadsheet for bills and 10 days before the due
date I want the cell to fill yellow. And then on the due date, I want the
cell to fill red.

Thanks in advance for the help!

 

[Eric]

I almost forgot. After I input an amount paid into the cell (meaning I paid
that month's bill) I don't want the fill color program to execute, I just
want it left white.

 

[T. Valko]

Try this...I'm assuming you're using Excel 2003 or an earlier version.

Assume A2 = due date
B2 = either date paid or amt paid

Select the cell you want to format
Goto the menu Format>Conditional Formatting
Condition 1 - turn cell RED
Formula Is: =AND(A2<>"",B2="",TODAY()>=A2)
Click the Format button
Select the Patterns tab
Select a shade of RED
Click OK
Click the Add button
Condition 2 - turn cell YELLOW
Formula Is: =AND(A2<>"",B2="",TODAY()>=A2-10)
Click the Format button
Select the Patterns tab
Select a shade of YELLOW
OK out