There is no built in function in Excel to do that, but there is a macro you
can use.

If you want it, you can do a search in the search for box with count color.

"JimW" wrote:

There might also be text in the cell but I want to count it based strictly on
the color

"Sean Timmons" wrote:

Which version of Excel do you have?

"JimW" wrote:

Is there a formula that will count cells that contain different colors. Blank
with no data just colored.