counting cells in a column based on thier color
 

See

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"rjkulesa" wrote in message
...
Hello all:
I have 100 random numbers in column A. The majority of the cells have the
normal transparent background. Some of the cells are shaded blue, red, and
green. I would like to write a formula (or 3) that sums all the blues, then
returns the sums of all the reds, and then sums all the greens. Cells that
have the transparent backgrounds are ignored. Any ideas?

Thanks.
rjkulesa