Have one checkbox auto check a different checkbox when checked

[Asheton Richardson]

Hello,

I am making a pricing sheet and I need to have different pairs of checkboxes check together when one is checked.

For example, when they purchase a license, they have to automatically purchase a year of maintenance so I need that checkbox to be checked when the license box is checked.

I plan on locking out the maintenance checkboxes for users but I need them to visually check when the corresponding license box is checked.

Is this possible?

Thanks!!

 

[Luke M]

You could link the maintenance checkbox to a cell which contains a formula. Formula could then be:
=CellLinkedToLicense = TRUE
and the maintenance checkbox will now mimic the license box.