recognition of coloured squares

[Guest]

what is the formulae for excel to recognise coloured squares and add up the
content?

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

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]

You can also use it to pick up the colorindex number from a cell, like

=SUMPRODUCT(--(Colorindex(A1:A100)=Colorindex(A1))

This will find all instances of the colour in A1 in A1:A100.

Or you could colour a cell, say H1, and use H1 in the above formula.

You can also get the ColorIndex numbers by looking up ColorIndex Property in
VBA help.

--

HTH

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