Google Apps Script: Apply formatting rule to a spesific sheet

Question

according to documents: https://developers.google.com/apps-script/reference/spreadsheet/conditional-format-rule-builder

var sheet = SpreadsheetApp.getActiveSheet();

But i only want it to be in a spesific sheet called Resultat.

 var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("resultat");

But with this sheetByName, i get :

TypeError: ThisSheet.newConditionalFormatRule is not a function

code to call:

 var ThisSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("resultat"); var range = ThisSheet.getRange("C:D") // only want it to select C element. ThisSheet.clearConditionalFormatRules(); var rule1 = ThisSheet.newConditionalFormatRule() .whenTextContains("NO") .setBackground("#b3cfb0") .setRanges([range]) .build(); var rules = ThisSheet.getConditionalFormatRules(); rules.push(rule1); ThisSheet.setConditionalFormatRules(rules);

Is that a typo? you wanted sheet instead of ThisSheet ? where is ThisSheet defined? — Marios
– Marios, Commented Feb 22, 2021 at 12:29

Tanaike · Accepted Answer · 2021-02-22 12:15:30Z

Modification points:

From your script, I cannot understand about ThisSheet. If ThisSheet is sheet of var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("resultat");, newConditionalFormatRule() is the method of Class SpreadsheetApp. By this, the error occurs.

When ThisSheet is sheet of var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("resultat");, how about the following modification?

Modified script:

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("resultat"); var range = sheet.getRange("C:D") // only want it to select C element. sheet.clearConditionalFormatRules(); var rule1 = SpreadsheetApp.newConditionalFormatRule() .whenTextContains("NO") .setBackground("#b3cfb0") .setRanges([range]) .build(); var rules = sheet.getConditionalFormatRules(); rules.push(rule1); sheet.setConditionalFormatRules(rules);

By above modified script, the conditional format rule is set to the range of "C:D".
If you want to set the conditional format rule to the column "C", please modify var range = sheet.getRange("C:D") to var range = sheet.getRange("C:C").

Reference:

newConditionalFormatRule()

@maria Thank you for replying. I'm glad your issue was resolved.

Collectives™ on Stack Overflow

Google Apps Script: Apply formatting rule to a spesific sheet

1 Answer 1

Modification points:

Modified script:

Reference:

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modification points:

Modified script:

Reference:

2 Comments

Related