You have understood correctly. There is another paper on CF there
http://www.xldynamic.com/source/xld.CFConditions.html

As to the quoted constraint, if you build it into SUMPRODUCT, you can add
another condition there.
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:65cbf4a6b5e73@uwe...
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