Many thanks forthe link but it seems to dpend on = ColorIndex numbers which i
cannot find despite using the formulae .I het #NAME?or #REF?
Any suggestions?
Thsnks for your interest


"Bob Phillips" wrote:

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"princecharlie" wrote in message
...
what is the formulae for excel to recognise coloured squares and add up
the
content?