Color Format

[Reggie]

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.

 

[Peo Sjoblom]

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


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