Color Format
 

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.

Not by using any built in functions, you need VBA see:


http://www.cpearson.com/excel/colors.htm

--

Regards,

Peo Sjoblom


"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.

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.