You need a VBA function to do this. See
www.cpearson.com/excel/colors.htm for code and examples.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Anjin Topeng" <Anjin wrote in
message
...
I have a colum, filled with text in 5 different colors. How can
I count the
cells with text in red, green or blue ?