Excel offers plenty of functions, but sadly, none of them can be used directly to calculate the count of color-coded cells. Also, there’s no built-in way (whatsoever) to do so in Excel.

In Microsoft Excel, you are not just able to count characters in a single/multiple cell, but also specific characters in a cell or range of cells.

Need to find cells with specific text? The COUNTIF formula in Excel has got you covered.