Count highlighted cells
 

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.

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


"Robbie in Houston" <Robbie in wrote in
message ...
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.

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.