recognition of coloured squares
 

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

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?

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?

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)


"princecharlie" wrote in message
...
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?