问单元格在该行中的任何单元格包含验证错误时返回验证错误引用。

EN

function cellerrors(ra1 = "A1:M1") {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getActiveSheet();
  const rg = sh.getRange(ra1);
  const ri = rg.getRow();
  const ci = rg.getColumn();
  const vs = rg.getDisplayValues();
  let o = vs.map((r, i) => {
    let row = [];
    r.forEach((c, j) => {
      let cv = sh.getRange(ri + i, ci + j).getDataValidation().getCriteriaValues();
      cv[0].unshift('');
      if (!~cv[0].indexOf(c)) {
        row.push(`Valid Values: ${cv[0].join(',')} Row: ${ri + i} Col: ${ci + j} Error - Value: ${c}`);
      } else {
        row.push(`Valid Values: ${cv[0].join(',')} Row: ${ri + i} Col: ${ci + j} No Error - Value: ${c}`);
      }
    })
    return row;
  })
  Logger.log(JSON.stringify(o));
  sh.getRange("A2").setValue(o.flat().join('\n'));
}