May 23 2019 04:55 AM
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.
Thanks
May 23 2019 06:15 AM
@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.
May 23 2019 07:20 AM
Jun 03 2019 04:41 AM