Advertisement
Guest User

Untitled

a guest
Jul 15th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. var hojaCamada = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(camada);
  2. var range = hojaCamada.getRange("K6:K100");
  3. var rule = SpreadsheetApp.newConditionalFormatRule()
  4. .whenFormulaSatisfied('=Y($J6 < $I$3;$K6<1)')
  5. .setBackground("#ea9999")
  6. .setRanges([range])
  7. .build();
  8. var rules = hojaCamada.getConditionalFormatRules();
  9. rules.push(rule);
  10. hojaCamada.setConditionalFormatRules(rules);
  11.  
  12. var spreadsheet = SpreadsheetApp.getActive();
  13. var sheet = spreadsheet.getSheetByName("x");
  14. sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
  15. sheet.clearConditionalFormatRules();
  16. var conditionalFormatRules = spreadsheet.getActiveSheet().getConditionalFormatRules();
  17.  
  18. var rule = SpreadsheetApp.newConditionalFormatRule()
  19. .setFontColor('#a2c8ec')
  20. .setBackground('black')
  21. .whenFormulaSatisfied('=$D1=1')
  22. .setRanges([spreadsheet.getRange('A:J')])
  23. .build();
  24. conditionalFormatRules.push(rule);
  25.  
  26. sheet.setConditionalFormatRules(conditionalFormatRules);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement