# How to Count Cells by Color in Microsoft Excel

> To count cells by color in Microsoft Excel, select the colored cells and header row, go to the Home tab, and choose Filter. Next, open the filter dropdown, select Filter by Color, and choose your desired color to view the count of visible cells in the bottom-left corner.

Canonical: https://livedemo.ai/tutorials/how-to-count-cells-by-color-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35f0ab56e05a00fda749/preview?step=1

## Steps

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.