Can you have a cell "unlock/unprotect" when a value is entered in another.
Ex.
Using Cells A1 and A2.
A2 is locked. But when "PO" is entered in A1, i want A2 to except user input.
But if any other value (including in it is blank) is present in A1, I want A2 to remain locked
Bookmarks