CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulacountingadd-ongs-conditional-formatting
hardy
hardy

Reputation: 557

Conditional formatting & Cell color count?

I'm using conditional formatting in my google sheet and provide background color on value-based. My goal is to apply a formula that will automatically count the number of cells that have the same background color. However, the issue is that since they are not color-coded by 'fill color', but based on a conditional formula, I can't seem to find an easy way to count the cells with the same background color. So please help me with this.

Upvotes: 2

Views: 510

Answers (1)

player0
player0

Reputation: 1

to count background color you can use this addon:

https://chrome.google.com/webstore/detail/custom-count-and-sum/njiklelndjpdbdngfkdgeijcpfabfgkb

and then you can simply use this formula:

=COUNTBACKGROUNDCOLOR("A2:A20", "A3")

A2:A20 being the range and A3 being the example of color to count

0

Upvotes: 2

Related Questions