Excel: Can I use Fill_Color Attribs to count elements?

[DrKilbert]

In Excel 2000: I'm needing to simply count elements based on the Fill Color
of a series of cells. I know I can use the countif() function but haven't
been able to find a list of system variables and their corresponding
elements.

 

[Chip Pearson]

You need to use a VBA user defined function to count by color.
See www.cpearson.com/excel/colors.htm for example code and
functions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
news:[email protected]...

 

[DrKilbert]

Thanks Chip, been out of the loop too long and taking me a bit to get back on
my feet. Appreciate the pointer.