See Chip Pearson's site for code.

http://www.cpearson.com/excel/colors.htm

Cannot be done with Excel native Functions.


Gord Dibben Excel MVP

On Tue, 15 Feb 2005 15:35:02 -0800, "Robbie in Houston" <Robbie in
wrote:

I need a formula to count how many manually highlighted/shaded/colored cells
are in a specific column in a worksheet. I have a list of items
(collectibles) that I highlight as I find. I want to keep track of the total
number of items I have without having to physically count all the items.