Conditional Formatting Question

  • Thread starter Thread starter unix-freak
  • Start date Start date
U

unix-freak

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
 
OK...this might help:
April 28 was a first charge on a 0.00 balance.

* Range of cells for charges = April 28 until () now -30 days for charges.
Then added the charges.

* Range of cells for payments = Payments made from April 28 to () now.

* Subtract the charges from the deposit and that amount would be the amount
out of grace period that would show on a bar chart.

Possible?
 
Back
Top