I'd like to prevent a checkbox from being checked until certain criteria have been met. I've tried protecting the linked cell but that doesn't seem to do anything.
Image:
Here's what I'd like. The first check box on the top can't be checked unless every checkbox in the lower range has been checked. If a user tries, they'll receive a pop up saying "please make sure all criteria have been met".
I feel like I should be able to do something with the linked cell to make this happen but I can't seem to figure it out. Help would be greatly appreciated
Image:
Here's what I'd like. The first check box on the top can't be checked unless every checkbox in the lower range has been checked. If a user tries, they'll receive a pop up saying "please make sure all criteria have been met".
I feel like I should be able to do something with the linked cell to make this happen but I can't seem to figure it out. Help would be greatly appreciated