Check this out

http://www.xldynamic.com/source/xld.ColourCounter.html

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"FARAZ QURESHI" wrote in message
...
Can you sort rows of different colors in categories by formula or macro?
Or
Can you make up a formula or macro like:
if cell A1 is filled with red color the result is "R" otherwise "G".