Of the 56 colors only 40 colors appear on the palette. The colors 1-16 are widely understood color names from the VGA color palette. But having to filter the list each time may not be good enough.īecause functions such as COUNTIF cannot count by cell colour, we will need to create our own custom function (also known as User Defined Functions or UDF’s) to get the job done.
We can find out how many cells by filtering the list by colour, and maybe use the AGGREGATE function to return the count. If you have ever tried to count cells by colour in Excel, you may have noticed that Excel does not contain a function to accomplish this.
