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

Try Bob Phillips' nice page on this at:
http://www.xldynamic.com/source/xld.....html#counting
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...
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,

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

Ray

"Max" wrote in message
...
Try Bob Phillips' nice page on this at:
http://www.xldynamic.com/source/xld.....html#counting
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...
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

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 ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...
Max,

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

Ray

Max,

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

Best regards,

Ray

"Max" wrote in message
...
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 ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...
Max,

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

Ray

You're welcome, Ray !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray" wrote in message
...

Max,

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

Best regards,

Ray