Locking cells dynamically

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.

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

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

"Yossi" wrote:

> 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.