Finding Formatted Cells

[bcnu]

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.

 

[Bob Phillips]

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]

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