Count

[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

 

[Max]

Try Bob Phillips' nice page on this at:
http://www.xldynamic.com/source/xld.ColourCounter.html#counting

 

[Ray]

Max,

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

Ray

 

[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 ..

 

[Ray]

Max,

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

Best regards,

Ray

 

[Max]

You're welcome, Ray !