auto tick box checked dependent on all dots green

rob.begley

Hi I have several columns when once all green dots turns the row green, done with conditional formatting, however I have a column with a check box and want a formula that automatically ticks the checkbox once all dots in row are green, please can someone help?

Ofir Marco

I  think you are looking for a formula like this in your checkbox column:

=IF(AND([Ind #1]1 = "Green", [Ind #2]1 = "Green", [Ind #3]1 = "Green"), 1, 0)

Is that what you are trying to achieve (see screen shot below)?

rob.begley

Thank you 

That' exactley what was looking for, I ended up meeting some if functions and using a ball to show green instead of a check box 

I will have a play tomorrow as I would prefer the check box 

Many thanks

Rob

Ofir Marco

Your'e welcome.

Let me know if you need help during the process.