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