回答編集履歴
1
文法の修正
answer
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
var range = sheets[i].getRange('A1:Z1');
|
9
9
|
var rule = SpreadsheetApp.newConditionalFormatRule()
|
10
10
|
.whenTextEqualTo(100)
|
11
|
-
.setBackground("FF0000")
|
11
|
+
.setBackground("#FF0000")
|
12
12
|
.setRanges([range])
|
13
13
|
.build();
|
14
14
|
var rules = sheets[i].getConditionalFormatRules();
|