Locking/Unlocking based on another cell value

I

Iriemon

I need to be able to lock/unlock certain cells based on the value contained
in another cell:

Cell A1="yes" - unlock B1 and lock C1
Cell A1="no" - lock B1 and unlock C1

Any help is greatly appreciated.

J
 
Top