I'm trying to set an entire row (columns a:w) in a sheet to bold when the value in column C = "NEW#####". I'm struggling with how to get the whole row bold.
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("FormTest");
var range = sheet.getRange("A:W");
sheet.clearConditionalFormatRules();
var rule1 = SpreadsheetApp.newConditionalFormatRule()
  .whenFormulaSatisfied('=$C="NEW#####"')
  .setBold(true)
  .setRanges([range])
  .build();
var rules = sheet.getConditionalFormatRules();
rules.push(rule1);
sheet.setConditionalFormatRules(rules);
 
    