If it is manually coloured, see
http://www.xldynamic.com/source/xld.ColourCounter.html, if it is
conditionally formatted, see
http://www.xldynamic.com/source/xld.CFConditions.html
--
__________________________________
HTH
Bob
"The Rook" wrote in message
...
I have colomn B populated with times in the [h]:mm:ss format. These cells
are either coloured green or red depending on the data.
I am wantint to add all the reds together and all the greens together. is
this possible?
regards