Color Formula/Macro

0

I am wanting to know if the following was possible and if so how do I go about it. 

I have a spreadsheet and I want it to calculate that if all cells are green then it gives me a yes or tick in the cell required.  If all cells do not equal green then it gives me a no or cross in the cell required.

How can I do this.  Please note that I have used conditioning formatting for the coloured cells. 

Answer
Discuss

Answers

0

Use the same formula[s] which turn[s] the cell colour to green to set the checkmark.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login