Conditional formula based on cell color

Copper Contributor

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

3 Replies

@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.

Hi,

 

How about this approach?

Screenshot_1.png

 

Please find it in the attached file.

 

@BSTREET

@Haytham Amairah 

 

This is perfect!  Thank you very much.