Conditionally protect a cell

[bigjim]

I am using exell 2003. I want to allow access to a protected cell only if
the contents of another cell equal a certain value. for example: Cell b5 is
protected and the sheet is protected. If a user enters "Overweight" in cell
b2, I want them to be able to enter data into cell b5. With any other entry
in cell b2, I don't want them to be able to enter anything in cel b5. Can
this be done? I would appreciate any help.

Thanks,
Jim

 

[Jim Thomlinson]

There is no way to conditionally lock a cell. In this case I would be
inclined to use custom validation. In the cell that you want protected add
the following
Data -> Validation -> Custom ->
=B5 = "Overweight"
and uncheck allow blanks.

if you try to enter something into the cell and B5 <> Overweight then an
error alert will pop up not allowing the change. Not that this can be
defeated by addin Overweight , making the change and then removing overweight.

 

[bigjim]

Thank you very much. That's not ideal, but I can make it work. I didn't
think of using that, but that will solve my problem.

Jim