Check boxes - when one box is checked, I want a 2nd box to auto ch

[Guest]

Hi---I am setting up a form with various check boxes. I want to set up a
range of check boxes so if any of these boxes are checked, then one
corresponding check box if also checked. On the flip side, if none in the
range of boxes are checked, then the one corresponding box is also not
checked.

I hope this can be done with a formula or conditional formatting, instead of
a macro....if it takes a macro, whoever resonds to this question, please
explain in easy terms---I don't have a lot o fmacro experience.

Thanks!!!

 

[Dave O]

A boolean checkbox reflects the TRUE / FALSE value of the cell it links
to. In a simplified example, say you have a checkbox1 linked to cell
A10. When you check checkbox1 A10 flips to TRUE. You can have another
box called checkbox9 and link it to cell B10; the formula in B10 can
say =IF(A10=TRUE,TRUE,FALSE) . This will cause checkbox9 to match the
checked or unchecked status of checkbox1.

Back to your example, you could set up multiple boxes, call them
checkbox1, checkbox2, and checkbox3; you can figure out the appropriate
logic for cell B10's formula. If any of boxes 1, 2, or 3 are checked
and you want checkbox9 to show checked, the formula in B10 is
=IF(OR(A10=TRUE,A11=TRUE,A12=TRUE),TRUE,FALSE)

.... assuming boxes 1, 2, and 3 are linked to A10, A11, and A12.

 

[Dave O]

A boolean checkbox reflects the TRUE / FALSE value of the cell it links
to. In a simplified example, say you have a checkbox1 linked to cell
A10. When you check checkbox1 A10 flips to TRUE. You can have another
box called checkbox9 and link it to cell B10; the formula in B10 can
say =IF(A10=TRUE,TRUE,FALSE) . This will cause checkbox9 to match the
checked or unchecked status of checkbox1.

Back to your example, you could set up multiple boxes, call them
checkbox1, checkbox2, and checkbox3; you can figure out the appropriate
logic for cell B10's formula. If any of boxes 1, 2, or 3 are checked
and you want checkbox9 to show checked, the formula in B10 is
=IF(OR(A10=TRUE,A11=TRUE,A12=TRUE),TRUE,FALSE)

.... assuming boxes 1, 2, and 3 are linked to A10, A11, and A12.