how do I get a font color to change after a certain date?

[Guest]

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

 

[RagDyer]

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!
==============================================

 

[Guest]

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

 

[Gord Dibben]

Charree

Select the cell and Format>Conditional Formatting>Formula is:

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

Format to red font and OK your out.


Gord Dibben Excel MVP

 

[Guest]

thank you!

Charree

Select the cell and Format>Conditional Formatting>Formula is:

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

Format to red font and OK your out.


Gord Dibben Excel MVP

 

[edcosoft]

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