Locking cells dynamically

Y

Yossi

Hi,
Is there an option in Excel to lock cells on a certain condition?
For example if a value in A1 is "X" than cell B1 will be locked otherwise it
will be unlocked.
 
W

Widemonk

Have a play with Cell Validation, particularly the Custom section.

In B1, set validation to Allow > Custom, Formula = A1<>"X"
 
Top