My preference for that is to use data validation with a custom validation.
Then you can use a formula to check the values of other cells to either allow
or disallow entry. Fot ease of use to your end users you may want to add a
conditional format to indicate when the cell is available to be edited...

Data | Validation | Custom | Add a formula and uncheck Ignore Blanks
--
HTH...

Jim Thomlinson


"David Bruce" wrote:

I am trying to find a way of automatically protecting a cell if an adjacent
cell has a specific value whilst if that cell has a different value the cell
would be unprotected.

For example if I am aiming to have a column with values in that will be
entered but if a field next to it has a 1 in the value field will then be
locked. But if the 1 is changed to a 0 the value field could then be edited.

Many Thanks for any help.

David