Hi,
In my spreadsheet cell B2 is a 'Yes / No' option field
If you select 'Yes' then Cell 'B3' is clear and you can enter data.
If you select 'NO', then Cell 'B3' gets a grey colour, BUT, when you select 'No' the cell turns Grey, I would like the cell to be protected so that you cant enter anything in cell 'B3' and anything in cell 'B3' if any is deleted
There are about 30 plus Yes / No selection per worksheet
Hope this makes sense
Propolis
In my spreadsheet cell B2 is a 'Yes / No' option field
If you select 'Yes' then Cell 'B3' is clear and you can enter data.
If you select 'NO', then Cell 'B3' gets a grey colour, BUT, when you select 'No' the cell turns Grey, I would like the cell to be protected so that you cant enter anything in cell 'B3' and anything in cell 'B3' if any is deleted
There are about 30 plus Yes / No selection per worksheet
Hope this makes sense
Propolis