macro.gs

/** @OnlyCurrentDoc */

function Escala() {
  var spreadsheet = SpreadsheetApp.getActive();
  
  var start_row = spreadsheet.getActiveRange().getRow();
  var final_row = spreadsheet.getActiveRange().getLastRow() + 1;
  
  var conditionalFormatRules = spreadsheet.getActiveSheet().getConditionalFormatRules();
  
  for (var row=start_row; row < final_row; row++) {
    conditionalFormatRules.push(
      SpreadsheetApp.newConditionalFormatRule()
        .setRanges([spreadsheet.getDataRange().getCell(row,2).offset(0, 0, 1, 10)])
        .setGradientMinpoint('#E67C73')
        .setGradientMidpointWithValue('#FFFFFF', SpreadsheetApp.InterpolationType.PERCENTILE, '50')
        .setGradientMaxpoint('#57BB8A')
        .build()
    );
  }
  
  spreadsheet.getActiveSheet().setConditionalFormatRules(conditionalFormatRules);
};