Setting up a Spreadsheet in Excel...

Money_Saver

for banking and stuff etc figures.

I'd like to set up a spread sheet so I can enter income on say 01st Each month, then enter my bills due on a particular date. A cell to show a balance once the amount has been deducted or a credit has been received on a particular date. I think this will help me enormously to budget so i can tell on any given day what my balance will be if xyz bills have been taken.

It too would be helpful if the cell could change colour once I enter my overdraft.

My knowledge of excel 2007 is somewhat limited.
I hope that makes sense.
Thanks for any info on how to achieve this best.

Asked in Bank Section also.

fwor

It's easy enough to put one together yourself, but have you tried the spreadsheet version in the budget planning tools section of this site?

http://www.moneysavingexpert.com/banking/Budget-planning

If that doesn't do what you want, put "excel budget planning template" into your favourite search site - just beware the ones that appear to be free but don't work properly unless you pay for them!