Look up "Conditional Formatting" in the Help files,
And at Debra's web site:

http://www.contextures.com/xlCondFormat01.html

And post back with any questions.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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