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.

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.

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.