Count

R

Ray

I would like to count the cells of a column which are equal to a specific
colour of background. Can someone advise how to accomplish it.

Thanks,

Ray
 
R

Ray

Max,

Thanks for your pointer. However, I am not familiar with creating VBA. Is
it very complicate to create?

Ray
 
M

Max

Ray,

I've put together a sample file (~ "starter's kit") which contains an
implementation of Bob Phillips' ColorIndex Function from his "Processing
Coloured Cells" page at:
http://www.xldynamic.com/source/xld.ColourCounter.html
and some examples on how to use the UDF in Excel

Here's the link to the sample file (construct details inside):
http://cjoint.com/?micQQgFQvj
CountCellsByFillColor_Using_BobPhillips_ColorIndex_UDF.xls

Hope the sample helps to get you started ..
 
R

Ray

Max,

Thanks a million for your detail and crystal clear instructions!! Learn a
lot from you.

Best regards,

Ray
 
Top