My daughter is about to be deployed overseas and asked me for some help with her budget since she will be in a location without much in the way of tech.
I have the base spreadsheet set up and working but I have what I hope is an easy question.
How can I set up a formula that will add the contents of A1:A15 but remove a cell if its color changes to say green? I want an easy way for her to color code what she has paid and have a running remainder.
@BSTREET , that's only with VBA programming. Formulas work with cells values, not with their properties as color. Alternatively you may set some flag in B1:B15 (e.g. "x") for what was paid what not, and use SUMIF() to calculate total expenses.
In additional for better visibility you may apply conditional formatting to green paid items.