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

--

HTH

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


"Reggie" wrote in message
...
Can I get Excel to tell me how many items in a column are
colored red? I would just count them, but the column has
over 40,000 rows.