I've been trying to build a work book that will allow me to better manage my budget. All of the things that I've seen available don't really meet my needs, and I co-worker recommended this site to get help with some of the formulas that I'm trying to do. What I want to be able to do is log my expenses on one sheet that end up falling into one of three categories, and then on another sheet total all the expenses that are associated with those three individual categories in a single cell (in the attached file, it would be H8, 9, and 10). Then, if the totals fall within what I've allotted myself (in the cells next to where the totals would be added up) they'd highlight as green and if they went over they'd highlight as red. After trying to figure it out myself for a couple weeks, it's become very apparent how excel retarded I am so any help would be appreciated.
Bookmarks