Counting the number of coloured cells

  • Thread starter Thread starter Mat][
  • Start date Start date
M

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
 
Mat][ said:
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?
Click to expand...

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
Click to expand...
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
 
Back
Top