Hello,
Is there a way to lock all cells within a range except for a particular row range that matches a particular criteria??
For instance, if "3816" is in B1 then D8:K8 are "unlocked" and the user can adjust the cells per the data validation drop-down; but D4:K7 are locked.
Thanks for advice with this.
Is there a way to lock all cells within a range except for a particular row range that matches a particular criteria??
For instance, if "3816" is in B1 then D8:K8 are "unlocked" and the user can adjust the cells per the data validation drop-down; but D4:K7 are locked.
Thanks for advice with this.