Conditional Formatting Question

Giganews Newsgroups
Subject: Conditional Formatting Question
Posted by:  unix-freak (mandrakemani…@yahoo.com)
Date: Sat, 1 May 2004

Hi all,

I have a spreadsheet with multiple worksheets. Each worksheet is for an
account. For my credit card account worksheets, I would like to do some
conditional formatting that would highlight a range of cells indicating that
those charges are out of "grace period" with a certain color, for example.
Is this possible? It seems that I  would have to start it at a 0.00 balance
/ date. 30 days later if any charges had not been paid, it would highlight.
I manually enter all charges/payments in it with the actual posting date.

It would also be cool if a had a bar graph that is a calculation of how much
at the current date is having interest applied to it, which would be nothing
more than just adding the range of cells that were conditionally
highlighted.

Thanks

Replies