function countColoredCells(countRange,colorRef) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = activeRange.getSheet(); var formula = activeRange.getFormula(); var rangeA1Notation = formula.match(/\((.*)\,/).pop(); var range = activeSheet.getRange(rangeA1Notation); var bg = range.getBackgrounds(); var values = range.getValues(); var colorCellA1Notation = formula.match(/\,(.*)\)/).pop(); var colorCell = activeSheet.getRange(colorCellA1Notation); var color = colorCell.getBackground(); var count = 0; for(var i=0;i