Thread
:
how do I 'count' the number of cells with a text in red or black?
View Single Post
#
2
Chip Pearson
Posts: n/a
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 ?
Reply With Quote