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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I 'count' the number of cells with a text in red or black? (https://www.excelbanter.com/excel-worksheet-functions/5619-how-do-i-count-number-cells-text-red-black.html)

Anjin Topeng

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

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

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

Anjin Topeng

Chip.

Thanks !

"Chip Pearson" wrote:

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 ?

All times are GMT +1. The time now is 02:07 PM.