Excel Help Required

Bennie-Mac

Bennie-Mac

Bennie-Mac

Soldato
Joined
10 Sep 2008
Posts
11,973
Location
Bangor, Northern Ireland
Hi folks

Ive never really used Excel before, apart from very basic spreadsheets etc, and was wondering if i could feed off your wisdom for a yearly budget calculator im trying to create.

I dont even know if the things im wanting to do are possible with Excel (2003 by the way) so please bear with me and ill try and explain what i need as best i can. :)

Here is a screenshot of my work in progress:

75008324.png


Edit - That didnt come out as planned... Link to larger image here - http://img683.imageshack.us/img683/6712/22999329.png

There are a couple of things im trying to do, which ive listed below:

What i would like is for the "Account Balance" cell to update whenever the check box is clicked, for example if i click on Mortgage paid, that would subtract the Mortgage amount from the account balance. I would like the same to happen to the "Still Outstanding" cell whereby it would subtract the paid item from the total monthly outgoings.

Next is the bit im not sure is even possible, its not a necessary feature, but would be nice to have nonetheless. As you can hopefully see ive added due dates for all the outgoings, but what im wondering is whether its possible to change the colour of the cells with the amounts in them, based on the date? i.e If the bill is overdue it turns red, if its due in the next 5 days it turns orange and if its paid it turns green.

I should point out that i will be adding in similar tables for Income and Misc Spendature, however i assume these will be pretty much the same formulas so once i get one problem sorted ill have sorted them all.

If anyone has any tips that would be greatly appreciated.

Thanks! :)
 
Last edited:
Ok it would seem i might be thinking the wrong way here or over complicating things. Lets say the Checkbox in cell D10 is ticked, i want that to subtract the amount in B10 from the account balance in B3. But also subtract B10 from B23.

I understand this is an "IF TRUE" function, but i dont know how to write this out as a formula so that it works...
 
izzop said:
Hi,

How did you get the checkbox in the cell?

Thanks
Click to expand...

It was a bit of a faff but i created the checkbox using the Checkbox button on the Forms toolbar, then i just dragged it into the cell. Then i left clicked on it and went to Format Control and under the Control tab at the end i assigned it to the cell it was in. Had to do that for each checkbox so it took a while
 
Last edited:
Having done that how have you hideen the TRUE or FALSE that gets displayed when it's ticked or un-ticked?
 
izzop said:
Having done that how have you hideen the TRUE or FALSE that gets displayed when it's ticked or un-ticked?
Click to expand...

Oh sorry, i actually assigned the checkbox to a random out of the way cell, so although i have the checkbox in D10, i assigned it to D110 just so its out of the way
 
izzop said:
I take it the example you've shown is a mockup of how you would like it to look like?
Click to expand...

No thats what ive done so far :)

Edit - Unless you mean with the colours etc for overdue payments then yeah i would like it to look like that, i just added them to show what i meant

izzop said:
That's what I did, gave the checkbox a white background.
Click to expand...

Or yeah that would probably have been easier :p
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom