问循环条件格式。

EN

function conditional() {
    var sheet = SpreadsheetApp.getActiveSheet();
    var numRows = sheet.getLastRow()+1;
    var numC = sheet.getLastColumn(); 

for (var t = 7; t = numC; t++){
    var range = sheet.getRange(2,t,numRows,1);
    var answer = sheet.getRange(2,t).getValue();
    var rule = SpreadsheetApp.newConditionalFormatRule()
   .whenTextEqualTo(answer)
   .setBackground("#00ff00")
   .setFontColor("#00ff00")
   .setRanges([range])
   .build();
   var rules = sheet.getConditionalFormatRules();
   rules.push(rule);
   sheet.setConditionalFormatRules(rules);

   var rule2 = SpreadsheetApp.newConditionalFormatRule()
  .whenTextDoesNotContain(answer)
  .setBackground("#ff0000")
  .setFontColor("#ff0000")
  .setRanges([range])
  .build();
   var rules2 = sheet.getConditionalFormatRules();
   rules2.push(rule2);
   sheet.setConditionalFormatRules(rules2);
   }
   }