Thank you Thank You Thank You. This data was very helpful. It not only
solved my problem, but taught me UDF's.

"Bob Phillips" wrote:

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

and http://www.rondebruin.nl/easyfilter.htm

--

HTH

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


"bcnu" wrote in message
...
I have a 50,000 line spreadsheet with highlight (color) formatting in some
cells. I'd like to count the number of reds and do a filter on the
yellows.
Is this possible with countif, and filter logic?

Thank you in advance.