在Google Apps脚本中使用循环在工作表中搜索值

function searchValue() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var searchValue = "要搜索的值";
  var range = sheet.getDataRange();
  var values = range.getValues();
  var found = false;

  for (var row = 0; row < values.length; row++) {
    for (var col = 0; col < values[row].length; col++) {
      if (values[row][col] == searchValue) {
        var cell = sheet.getRange(row + 1, col + 1);
        cell.setBackground("yellow");
        found = true;
      }
    }
  }

  if (!found) {
    Logger.log("未找到该值。");
  }
}