how do I 'count' the number of cells with a text in red or black?

[Anjin Topeng]

I have a colum, filled with text in 5 different colors. How can I count the
cells with text in red, green or blue ?

 

[Chip Pearson]

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



message
news:[email protected]...

 

[Anjin Topeng]

Chip.

Thanks !

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



message