Unlocking cell when a certain value is entered in another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emeryj - 24 Jan 2006 21:27 GMT

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

Signature

emeryj

Reply to this Message

SteveG - 24 Jan 2006 21:58 GMT

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

Signature

SteveG

Reply to this Message