Protect range to allow editing of **values only** (ie. protect all formatting)

Question

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?

Answer 1

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.