How to Count Cells by Color in Microsoft Excel
- George Apostolov
How to Count Cells by Color in Microsoft Excel: step-by-step guide
Select the cells containing colors, including the header row.
Go to the Home tab.
Click Sort & Filter, and choose Filter.
Click the filter dropdown, choose Filter by Color, and select your desired color.
The bottom-left corner of Excel will display the count of visible cells.
Quick answer: 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.
About this Microsoft tutorial
Find the count of colored cells in Microsoft by applying a color filter and viewing the visible cell count at the bottom-left. This guide shows how to count Cells by Color in Microsoft Excel in 5 steps, starting with "Select the cells containing colors, including the header row" and finishing with "The bottom-left corner of Excel will display the count of visible cells". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to count Cells by Color in Microsoft Excel?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Count Cells with Text Values in Microsoft Excel, How to Count the Words in Microsoft Excel and How to Create a Chart in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
