| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking Cells | Excel Discussion (Misc queries) | |||
| Help on locking cells | Excel Discussion (Misc queries) | |||
| Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
| Locking certain cells | Excel Worksheet Functions | |||
Linear Mode
