ExcelBanter - Locking cells dynamically

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Locking cells dynamically (https://www.excelbanter.com/excel-discussion-misc-queries/22161-locking-cells-dynamically.html)

Yossi

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.

Widemonk

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.

All times are GMT +1. The time now is 06:00 AM.