Forum Discussion

Former Employee

Oct 16, 2017

Get your questions ready for the Excel team

Get your questions ready for the Excel team! Join our Reddit AMA next Wednesday, Oct 18th at 12:30pm EST. http://msft.social/AJPg4i

excel

Joseph Shigley

Copper Contributor

Oct 18, 2017

I have color coded cells on my spreadsheet to designate different types of activity. Is there a way to count the number of cells that are, say, colored blue?

SergeiBaklan

Diamond Contributor

Oct 18, 2017

Hi Joseph,

That's using VBA, see the example here https://support.microsoft.com/en-us/help/2815384/count-the-number-of-cells-with-specific-cell-color-by-using-vba