Hi Bob,

Thank you very much for your assistance.

I've had a read through the text entitled Processing Coloured Cells.
Unfortunately, I think I'm still stuck based on the quoted constraint listed:

"the second shortcoming is that this technique at present does not cater for
cells that are coloured due to conditional formatting."

I think this excludes my scenario from using any of the techniques. Have I
understood this correctly?

Cheers,
Sam



Bob Phillips wrote:
See http://www.xldynamic.com/source/xld.ColourCounter.html

Hi All,

[quoted text clipped - 7 lines]
Thanks,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200609/1