Hi,
I'm looking to build a really simple budget management spreadsheet. I've attached an image of how I'd see the finished article look. I'd like columns with categories and prices and then on the right hand side a simple summary of each of the categories, the original budget and then to colour code if I am over or under budget for that category.
- I can manage setting up the categories via Data Validation
- I can get the dynamic summary of categories using UNIQUE (I think!)
- However I cannot get all of the totals for each category and then the status, ie +5 or -3 with colour red or green.
Any help appreciated, thanks
Paul
excel.png
Bookmarks