Size: a a a
R
clearConditionalFormatRules()EN
function removeConditionFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets()
for (var i = 0; i < sheets.length; i++)
{
ss.getSheets()[i].clearConditionalFormatRules()
}
}R
R
R
R
EN
R
R
EN
EN
EN
R
R
R
EN
function removeConditionFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets()
for (var i = 0; i < sheets.length; i++)
{
var sheet = ss.getSheets()[i];
var rules = sheet.getConditionalFormatRules();
for (var j = 0; j < rules.length; j++)
{
rules.splice(0, 4);
sheet.setConditionalFormatRules(rules);
}
}
}R
function removeConditionFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets()
for (var i = 0; i < sheets.length; i++)
{
var sheet = ss.getSheets()[i];
var rules = sheet.getConditionalFormatRules();
for (var j = 0; j < rules.length; j++)
{
rules.splice(0, 4);
sheet.setConditionalFormatRules(rules);
}
}
}EN
function removeConditionFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets()
for (var i = 0; i < sheets.length; i++)
{
var sheet = ss.getSheets()[i];
var rules = sheet.getConditionalFormatRules();
rules.splice(0, 4);
sheet.setConditionalFormatRules(rules);
}
}R
rules