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.

macbook placed on a table close to a cup of tea showing a screen filtering cells by text color or color fill in excel

Let’s take a closer look at this.

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.

opening the find feature in an excel spreadsheet

Unexpanded find tab in the find and replace window

Selecting Choose Format From Cell in the Find and Replace Window

Preview Button Filled With the Color We Want to Count Cells of

Find and Replace Feature Showing the Number of Cells It Found With the Same Color Fill