View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gnani Gnani is offline
external usenet poster
 
Posts: 1
Default 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.