Sum and count all colouredcellsinGoogleSheetsGetthe results for each fill or fontcolorthat exists in the range. I want myGoogleSheetscountcellsbycolorin each column so it is threecellsfor me, B19:D19 . ...GoogleSheetsfunctions you pick to use with ... ... another version of BackgroundColorIndex , but instead of referring to thecellitself, it will always refer to the correspondingcellin thesheet... I have set this up if conditional formatting, butformulasgetmessed around as I copypaste in thesheet, hence I'm looking to do the same with gs. You can use Apps Script to write your own small piece of code that can automate the task ofcoloringacellor range inGoogleSheets. Hi Jessica … In Excel, formulascannot directly detectcellcolors, including specific shades of acolor. Sum and count all colouredcellsinGoogleSheetsGetthe results for each fill or fontcolorthat exists in the range. If you ’ re usingGooglesheetsand you have a list of amounts that you want to sum or count based on the backgroundcolorof thecells, there ... ...google.com/apps-script/service_spreadsheet */ function onOpen() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var menu = [({name: ... This tutorial is about gettingGoogleSheetsto change thecolorof acellautomatically based on a rule that we provide it.