Need a BIG favour regarding Excel

.Kencs · 15 Dec 2009 at 09:14

I'm trying to get ontop of my finances ready for the new year, had a bad 2009 regarding money etc, so wanna get things sorted.

I need someone who is good with Excel to help me create a spreadsheet to manage what is coming in, going out.
I get paid monthly, my wife gets paid weekly, but we share the bills. So what I need is:

my income (monthly wage)
my wife's income (weekly wage)
what's going out
and also a column where it goes RED if im short and GREEN if il have some cash left over after the bills each month...

can anyone else with that please?

div0 · 15 Dec 2009 at 10:17

Column A = Income (per month)
Column B = Outgoings (per month)
Column C = Description/Detail/Date

Fill out a row for each transaction (money in/out). Eg you will have 4 rows of money in for your wifes weekly wage, one for your monthly wage and one for each outgoing transaction.

Then put the following formula in these cells:

D1 =SUM(A:A)
E1 =SUM(B:B)
F1 =D1-E1

Select cell F1, then;

Format - Conditional Formatting:

Condition 1: Cell Value is - Greater than - 0 - Format... - Patterns (chose Green colour)

Add >>

Condition 2: Cell Value is - Less than - 0 - Format... - Patterns (chose Red colour)

Explicit · 15 Dec 2009 at 10:48

Here be your goods:

http://www.megaupload.com/?d=B54KRHHH

Guest2 · 15 Dec 2009 at 11:29

Explicit said:
Here be your goods:

http://www.megaupload.com/?d=B54KRHHH

Fantastic, thanks. ive modified this and will start using this month. My money seems to fly out and im saving nothing at the moment

.Kencs · 15 Dec 2009 at 17:26

Explicit said:
Here be your goods:

http://www.megaupload.com/?d=B54KRHHH

Thanks

wesley · 15 Dec 2009 at 17:40

Explicit said:
Here be your goods:

http://www.megaupload.com/?d=B54KRHHH

thank you

icysniper · 15 Dec 2009 at 17:46

Explicit said:
Here be your goods:

http://www.megaupload.com/?d=B54KRHHH

very helpful thanks