Go to ‘Filter by Color’ and select the color.This will apply a filter to all the headers. Go to Data –> Sort and Filter –> Filter.In any cell below the data set, use the following formula: =SUBTOTAL(102,E1:E20).Here are the steps count colored cells in Excel: There are two background colors used in this data set (green and orange). Suppose you have a dataset as shown below: Use the SUBTOTAL function to count colored cells that are visible (after filtering).To count colored cells in Excel, you need to use the following two steps: #1 Count Colored Cells Using Filter and SUBTOTAL Using a Custom Function created using VBA.In this tutorial, I will show you three ways to count colored cells in Excel (with and without VBA): #3 Count Colored Using VBA (by Creating a Custom Function).Count Colored Cells using the Color Code.#2 Count Colored Cells Using GET.CELL Function.#1 Count Colored Cells Using Filter and SUBTOTAL.
