Add 1 to a cell based on font color of another cell

Copper Contributor

I already have a rule set up changing the font color of a cell to red or green based on other inputs. But is there a way to have a rule that "adds 1" to a cell based on if other cells font is red or green?

 

For example, once I enter some inputs, cell B5's font color on sheet 1 will either turn red or green. Can I have another cell "add 1" if B5 turns green and not add anything if it turns red? So if I have 12 sheets that all have a B5 that either turns red or green, can I have another "Summary" sheet that adds 1 to a cell for each B5 that is green in the other sheets?

 

Thanks in advance for any help if this is even possible. 

1 Reply
short answer is no, in cell formulas can't look at cell color
that said you can use the same logic being used to change the color. trying to look across multiple sheets would be easiest if you used a helper cell. for example B6 uses the logic that turns B5 red/green to indicate 0/1 and then sum B6 across sheets.