"Bear3164" wrote:


Hi Folks,

Has anyone out there ever tried to lock a range of cells based on a
condition. For example if there is a cell which is locked to everyone
but the select few, it it possible that on entering data into that cell
another range of cells can be locked down to prevent reprospective data
changes.
Looking for same. Need to lock cell B1 if there is data in A1 and vice
versa, lock A1 if B1 contains data.