| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 ? |
|
#2
|
|||
|
|||
|
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 ? |
|
#3
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| What defines number or text | New Users to Excel | |||
| Count cells with data | New Users to Excel | |||
Hybrid Mode
