Excel does not have a built-in function to count cells based on fill color or font color. However, there are some workarounds to achieve this. Using the Find feature is one of several workarounds to count colored cells in Excel without using any formula. Let’s take a closer look at this.
How to Count Cells With Specific Colors in Excel
To count cells that have a specific color fill, follow the steps below:
You can use the same process to count cells with colored text. The only difference would be that you need to select the cell with the same color text that you want to count cells for.
A downside of this method is that it is not dynamic, meaning the count won’t update automatically with changes to cell colors.
Similar to counting the colored cells, Excel makes it simple tofilter and sort data by color.
Efficiently Count Colored Cells in Excel
Counting colored cells can be effectively achieved using the Find feature. Though this method needs to be repeated when data changes, it provides an easy way to tally colored cells without formulas.
