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

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

Thanks, I got that far, I guess what I would need to know is the formula to
acheive that result. I saw nothing regarding dates, only values and formulas.
such as: if the date is 30 days past todays date in B3, change font to red.
I dont see a place to enter something like that.
I am not too advanced with excel formulas myself.
If anyone can be a little more specific, I'd appreciate it.
Thanks



"RagDyer" wrote:

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

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

thank you!

"Gord Dibben" wrote:

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

Per Dibben put the formula in all the cells of the column you want to
turn red and the "cellref" would be all the cells in the date column.,
ed