See if this works for you.
A few tips:
- When you type Y or N in the end column, the colour will change automatically.
- If you remove any rows because you are not having those things, just check that the sub-total is still adding up. To do this, click on autosum which is the one that looks like a backwards Z on the toolbar, and it will highlight the cells it is adding up. If it is wrong, just highlight the right cells.
- It should add up all the subtotals at the bottom and the underspent/overspent colour should change automatically. Any problems message me.