Counting the number of coloured cells

[Mat][]

Hi all,

I would love to be able to count the number of cells in a row that are
coloured yellow or the number of cells that are coloured green.

Is this possible?

Mat

 

[Harlan Grove]

I would love to be able to count the number of cells in a row that are
coloured yellow or the number of cells that are coloured green.

Is this possible?

If these colors are the result of conditional formatting, then use the same
conditions in a conditional sum. For example, if yellow corresponds to cells

= 100 but < 1000 while green corresponds to cells >= 1000, then the sum of

yellow would be given by

=SUMIF(Range,">=100")-SUMIF(Range,">=1000")

and sum of green would be given by

=SUMIF(Range,">=1000")

On the other hand, if there's no set pattern for the colors, you need to use
VBA to write user-defined functions to do this. See

http://www.cpearson.com/excel/colors.htm

 

[Bob Phillips]

See

http://www.xldynamic.com/source/xld.ColourCounter.html
Processing Coloured Cells


--

HTH

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