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

C

Charree

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
 
R

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

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
 
G

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
 
C

Charree

thank you!

Gord Dibben said:
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
Click to expand...
 
E

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
 
Top