How to Count Cells by Color in Microsoft Excel: 1-Min Guide

How to Count Cells by Color in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to count colored cells in Microsoft Excel using filters.

Quick summary

Counting cells by color in Microsoft Excel requires no formula — just the built-in Filter by Color feature, which lets Excel display a live cell count in the status bar. This method works for any fill color and takes under a minute to complete.

Steps

Select the cells containing colors, including the header row.
Go to the Home tab in the Excel ribbon.
Click Sort & Filter, then choose Filter to enable dropdown arrows on your headers.
Click the filter dropdown, choose Filter by Color, and select your desired color to show only matching rows.
Check the bottom-left corner of Excel — the status bar will display the count of visible cells matching your chosen color.

📌 Why this matters

Counting cells by color in Microsoft Excel is a common data analysis task that many users struggle to complete without a complex formula. The native Filter by Color method gives analysts and business users a fast, formula-free way to quantify color-coded data — such as flagged items, status categories, or priority tiers — directly within their existing spreadsheet. This technique works across all modern versions of Excel and requires no add-ins, making it accessible to any user who relies on color formatting to organize data. Mastering this workflow saves time and reduces errors when summarizing large, color-coded datasets.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel