Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var hojaCamada = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(camada);
- var range = hojaCamada.getRange("K6:K100");
- var rule = SpreadsheetApp.newConditionalFormatRule()
- .whenFormulaSatisfied('=Y($J6 < $I$3;$K6<1)')
- .setBackground("#ea9999")
- .setRanges([range])
- .build();
- var rules = hojaCamada.getConditionalFormatRules();
- rules.push(rule);
- hojaCamada.setConditionalFormatRules(rules);
- var spreadsheet = SpreadsheetApp.getActive();
- var sheet = spreadsheet.getSheetByName("x");
- sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
- sheet.clearConditionalFormatRules();
- var conditionalFormatRules = spreadsheet.getActiveSheet().getConditionalFormatRules();
- var rule = SpreadsheetApp.newConditionalFormatRule()
- .setFontColor('#a2c8ec')
- .setBackground('black')
- .whenFormulaSatisfied('=$D1=1')
- .setRanges([spreadsheet.getRange('A:J')])
- .build();
- conditionalFormatRules.push(rule);
- sheet.setConditionalFormatRules(conditionalFormatRules);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement