How to protect from editing only rows that are odd numbered?

Question

In Google Sheets how do I protect the rows in Column A which are odd from any kind of edits?

I would like to use this function

=ISODD(ROW(A1))

Protected sheets and ranges gives you this by default

Sheet1!A1

I can do this

Sheet1!A1:A1000

which will protect all 1000 rows but how do I use functions in that so I can only use ODD rows.

Here is a picture of that feature:

Answer 1

As mentioned in the comments on your question, I don't believe there is currently any way of manipulating range protection with Google Apps Script.

So the only option that I can think of is to manually apply the protection to 500 individual cells (in your example).

A workaround - that is not particularly tidy - is to use data validation to thwart (ultimately not prevent) entering data in even rows, with this sort of arrangement (accessed from Data, Validation...):

Savvy users who have access to the spreadsheet will be able to go in to data validation and circumvent this, though.

Answer 2

Google has created api for protecting sheets using google app script.

For example, to protect range A1:B10, You can run

var ss = SpreadsheetApp.getActive();
var range = ss.getRange('A1:B10');
var protection = range.protect().setDescription('Sample protected range');    

If You want to protect rows alternatively, You can try something like this

function alternateRowProtection() {
  var totalRows = SpreadsheetApp.getActiveRange().getNumRows();
  var sheet = SpreadsheetApp.getActiveSheet();
  var row = 1;
  while (row < totalRows)
  {
      if(row%2 == 0){
           sheet.getRange(row).protect().setDescription('This is protected.');    
      }
    row++;
  }
}