11 votes
Accepted

Can I protect the formatting of a Google Sheets?

The way to address the problem is to use a combination of custom function in google spreadsheet and google script. I will use examples to try to address solution for your problem Formula protection : ...
user avatar
1 vote

Remove All Protections on Selected Range

You want to delete all the protections, so you must be looking for a process that repeat itself, as long as the condition is matched. In your case as long there is a protection on C4:F30. Intuitively: ...
user avatar
  • 181

Only top scored, non community-wiki answers of a minimum length are eligible