我在google sheets中有一个google应用程序脚本，它提取数据并将其放入表中，然后发送电子邮件。它工作得很好，但我的问题是，如果一个表值（例如R[7]）等于FAULT而不是good时，如何将文本颜色更改为红色？

我已经添加了从google表中提取数据的另一部分代码。

顺晟科技：

function sendEmail() {
  
  const ss  = SpreadsheetApp.getActiveSpreadsheet();
  const ws = ss.getSheetByName('Sheet')//rename sheet name per your file;
  const headers = ws.getRange('A1:H1').getDisplayValues()//get table headers name;
  
  //assign variable to each header value
  const hospital = headers[0][0]; 
  const asset = headers[0][1];
  const time = headers[0][2];
  const helevel = headers[0][3];
  const hepressure = headers[0][4];
  const chillertemp = headers[0][5];
  const roomtemp = headers[0][6];
  const compressor = headers[0][7];

  const lr = ws.getRange('H14').getValues()//get last low row of active range, forula entered in B1 =countif(B3:B,"*")+2;

  const tablerangeValue = ws.getRange(2,1,18,9).getDisplayValues()//get range value, my data range start from 4th row and has 7 columns, pls chage per your need;

  const htmlTemplate = HtmlService.createTemplateFromFile('emailTable');

  htmlTemplate.hospital = hospital;
  htmlTemplate.asset = asset;
  htmlTemplate.time = time;
  htmlTemplate.helevel = helevel;
  htmlTemplate.hepressure = hepressure;
  htmlTemplate.chillertemp = chillertemp;
  htmlTemplate.roomtemp = roomtemp;
  htmlTemplate.compressor = compressor;
  htmlTemplate.tablerangeValue = tablerangeValue;

  const htmlForEmail = htmlTemplate.evaluate().getContent();
  
  
  var toEmail = 'user@email.com';
  var ccEmail = '';

  MailApp.sendEmail({
  to: toEmail,
  //cc: ccEmail,
  subject: "***Daily Readings***",
  htmlBody:htmlForEmail
    });

}

可以使用JavaScript。

例如，可以迭代所有值并检查值。