Unlocking cell when a certain value is entered in another cell

E

emeryj

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
 
S

SteveG

You can use Data Validation to accomplish this.

Select A2. Go to Data>Validation. Select Custom from the "Allow"
menu. In the Formula bar use

=A1="PO"

Deselect the Ignore Blank checkbox. Click on OK. Leave cell A1 blank
and try to now enter in a value in A2. Your users will get an error
message. When PO is in A1, any value will be allowed.

Does that help?

Steve
 
Top