In a column, I have many cells with different background color and I want to count them all. Cells don't have any value (empty, just background color).
Asked
Active
Viewed 54 times
0
-
1you will need a script for that – player0 Apr 16 '19 at 13:02
-
Add some code as to what you attempted? – Devesh Kumar Singh Apr 16 '19 at 13:25
-
1See the thread [Count the cells with same color in google spreadsheet](https://stackoverflow.com/questions/14365436/count-the-cells-with-same-color-in-google-spreadsheet) with script and non-script options – Karl_S Apr 16 '19 at 15:33
-
Range class has a method [getBackgrounds()](https://developers.google.com/apps-script/reference/spreadsheet/range#getbackgrounds) which will help you. – Александр Ермолин Apr 16 '19 at 17:13