Are they conditionally formatted. If so, see
http://www.xldynamic.com/source/xld.CFConditions.html. If it just normal
colouring, see http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

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


"Ann Knoff" <Ann wrote in message
...
Is there any way to total up a column by the colours of a cell?

I have a column that has Green, Yellow, Amber and Red cells and I need to
add up how many of each are there and then calculate the percentage.

Any help would be gratefully received!

Ann