Menu
I'm thinking this is not possible with the current version of Google Sheets, but thought I'd ask anyhow:
I want users to be able to enter values in a specific range within a spreadsheet, but I want to prevent them from altering the formatting (in particular the data validation and conditional formatting). I'd also like to prevent them from adding new rows/columns or from deleting rows/columns.
Is this possible?
369
You must give another user permission to edit the whole spreadsheet before you can protect a range. For example, if you want someone to only be able to edit column B, you would need to first give them permission to edit the spreadsheet, and then follow the procedure below to protect all the other columns.
Protected Ranges allows you to select a range of cells and choose which collaborators have permission to edit those cells, and which collaborators should only be able to view those cells.
To protect the conditional formatting, I make the range one row or one column bigger than what it needs to be and protect this extra row or column. Then, the conditional formatting including protected cells in their range cannot be modified anymore.
127
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
