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