Conditional Locking
How do i lock a range of cells based on values in some other cells.
OR
How do i lock a range of cells by giving some conditions.
Example:
If cell value of say B2 is "YES", then i need to lock a range of cells say
D2:G5.
If cell value of say B2 is "NO", then i need to unlock the same range of
cells.
|