format control on large number of checkboxes

D

Daesthai

When copying cells with formulae, excel auto-increments cell ID numbers.

Is there a similar setup/tool available for copying check boxes? I'm
creating a large number of checkboxes that affect conditional formatting in a
bunch of cells. Is there a way to do this without having to go into the
Format Control for each individual box to set a cell link?
 
Top