Counting cells with a specific background colour
 

I have a spreadsheet with several rows. The background of the rows can
either be coloured Red, Orange, Green or white.

What I want to do is have a running total for each colour, so that if a row
is set with a green background it will increment the Green total by one. If
an Orange row is changed to Red, the Orange count will drop by one, and the
Red count will go up by one.

Is this possible, and if so, how?

Rgds

Duncan

One way:

Assuming that the colors aren't applied by Conditional Formatting:

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

If they are applied by CF, do a conditional sum using the same condition
as your CF.


In article ,
Duncan wrote:

I have a spreadsheet with several rows. The background of the rows can
either be coloured Red, Orange, Green or white.

What I want to do is have a running total for each colour, so that if a row
is set with a green background it will increment the Green total by one. If
an Orange row is changed to Red, the Orange count will drop by one, and the
Red count will go up by one.

Is this possible, and if so, how?

Rgds

Duncan

See http://www.xldynamic.com/source/xld.ColourCounter.html, but note the
constraints

--

HTH

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


"Duncan" wrote in message
...
I have a spreadsheet with several rows. The background of the rows can
either be coloured Red, Orange, Green or white.

What I want to do is have a running total for each colour, so that if a
row
is set with a green background it will increment the Green total by one.
If
an Orange row is changed to Red, the Orange count will drop by one, and
the
Red count will go up by one.

Is this possible, and if so, how?

Rgds

Duncan