Count highlighted cells

[Robbie in Houston]

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.

 

[Steve]

I don't think you can do this with a formula (but, I'm often wrong). Try
Chip Pearson's site for information on functions to count colours:

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

HTH
Steve

 

[Gord Dibben]

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