Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 3rd 04, 07:46 PM
Anjin Topeng
 
Posts: n/a
Default 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   Report Post  
Old November 3rd 04, 07:53 PM
Chip Pearson
 
Posts: n/a
Default

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   Report Post  
Old November 4th 04, 06:42 AM
Anjin Topeng
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding cells, using text as number Pgsmom Excel Discussion (Misc queries) 4 January 10th 05 07:21 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
What defines number or text Danny J New Users to Excel 3 December 7th 04 07:27 AM
Count cells with data shoiley New Users to Excel 5 November 28th 04 07:23 PM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017