How to Count Cells by Color in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Select the cells containing colors, including the header row.
2. Go to the Home tab.
3. Click Sort & Filter, and choose Filter.
4. Click the filter dropdown, choose Filter by Color, and select your desired color.
5. The bottom-left corner of Excel will display the count of visible cells.