Charree

Select the cell and FormatConditional FormattingFormula is:

=cellref<TODAY() where cellref is the invoice due date

Format to red font and OK your out.


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 18:51:02 -0800, "Charree"
wrote:

I am trying to create a simple accounts receivable spreadsheet for a friend
who is a bit unorganized.
I would like the dollar amount to change to red after the invoice due date
(a seperate column on the sheet) can someone tell me if there is a formula
for a way to do that?

Thanks,

Charree