First off I am embarrassed to ask this. I am pretty decent with computers, but I have never EVER used excel in my life. Never
had a reason to... until now.
My old lady has been getting on my case to help with budgeting the bills. She however is NOT computer friendly. Tried quicken
and that ended up being a total disaster.
I don't want to sound technical, because I am not with excel at all. But the forum rules wants me to put what I have tried so
here it is and I am sure I am way off!
I have tried going through the formulas and found an IF formula, but cant seem to figure out how to attach the check box to a
specific cell or IF value = - then fill red, or if value = + fill green.
I am trying to make a budget
spreadsheet, I am looking for 2 things:
1. A formula that adds numbers in cells ONLY if the check box next to them
For example I have my expense in column F rows 5-10 and check boxes in column G 5-10.
I want the total (F12) to add only the cells that have a check in the check box corresponding with it in column G. And how do
I tie those check boxes to a cell?
2. A formula that fills the box green if the total is in the positive, red if
the total is in the negative.
I have been able to find out the basic stuff, but these 2 items seem to be a little
far more advanced than my actual comprehension goes.
Any help would be absolutely appreciated.