You don't have to do it manually.
Protect your data integrity by using Excel formulas to "lock" checkboxes so they only tick when specific conditions are met.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results