Getting a fill color on a certain date
 

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!

Getting a fill color on a certain date
 

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.

Getting a fill color on a certain date
 

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 FormatConditional 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

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
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!