问添加复选框以锁定Google工作表中下拉列表的单元格

EN

function onEdit(e) 
{
  var editRange = {
    top : 1,
    bottom : 1000,
    left : 2,
    right : 2
  };

  var cell = e.range;

  // Exit if we're out of range
  var thisRow = cell.getRow();
  if (thisRow < editRange.top || thisRow > editRange.bottom) return;

  var thisCol = cell.getColumn();
  if (thisCol < editRange.left || thisCol > editRange.right) return;

  var val1 = e.range.getRow();
  var val2 = e.range.getColumn();
  var validation = SpreadsheetApp.getActive().getSheetByName("Testing Sheet").getRange(val1, val2-1);


  if(cell.isChecked()){
    var rule = SpreadsheetApp.newDataValidation().requireValueInList(['Red', 'Blue']).build();
  }
  else{
    var rule = SpreadsheetApp.newDataValidation().requireValueInList(['Black', 'White']).build();
  }
  validation.setDataValidation(rule);
}