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. 

​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.   Read More

​