How to lock a row in a spreadsheet based on the value in a cell
Hi,
I am creating an personal expense datasheet. I would like to lock the entire
row if I click/ select the cell. Like I entered my expenses for that day in
cell A1 to A6. And I want that entire row to be locked if I put some value in
A7.
i.e. lets say I put a value 'Y' in cell 'A7'
I want the entire row to be locked if the A7 cell has a value Y and if the
A7cell is blank that row should be editable.
Hope, I am able to put my question correctly. Would appreciate a correct
response on it.
Thanks in advance,
Prasad
|