Utter noob in Excel

Andybtsn

Andybtsn

Andybtsn

Don
Joined
23 Oct 2005
Posts
44,364
Location
North Yorkshire
A trivial question for all of you out there who have an ounce of ability on Excel!

I'm sorting my outgoings spreadsheet for next year and have changed things around to make it easier to see how much I have left for particular debits/credits.

For example I have:



It's pretty simple, I just want the +/- column to show when I'm in credit or over the budget, so either green (plus) or red (minus). It seems I can do one and not the other? At the moment its showing in red despite me having that money left as a credit.

I have a drop down list on the right hand side that throughout the month I add what I spend on groceries and the "Actual budget" accumulates.

The figure then goes to a "total left for the month" figure so I can see how much I have left tin the joint easily. Obviously it being a minus or plus plays a big part in the money left for that month.
 
Actually I did have it working all the time in other cells but for some reason this grocery one just will not change to the correct +/-. I've cleared all rules from the cell, deleted it and started again yet it won't work like other cells. Bizarre.
 
I got it working, not sure how. Could you help with something else please?

Is there a formula if a figure displays in a negative (red) that I can make it display in another cell, If there are a number of negative figures in one block of cells I'd like them to add up and give me one definitive figure in a "not budgeted" for Cell.
 
You must log in or register to reply here.
Back
Top Bottom