Anjin Topeng

Posts: n/a

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 ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:12 PM.

About Us

"It's about Microsoft Excel"