Excel formula for counting text in a certain color?
 

Is there a formula for counting items that have been marked in a certain color?

Excel formula for counting text in a certain color?
 

i seriously doubt it.

"Toky" wrote:

Is there a formula for counting items that have been marked in a certain color?

Excel formula for counting text in a certain color?
 

Hi Toky. Try Chip Pearson's site at:
http://www.cpearson.com/excel/colors.htm. HTH
--
Sincerely, Michael Colvin


"Toky" wrote:

Is there a formula for counting items that have been marked in a certain color?

Excel formula for counting text in a certain color?
 

Hi "Toky",
You would need a User Defined Function.

See Chip Pearson's page
Functions For Cell Colors
http://www.cpearson.com/excel/colors.htm

If his examples are not clear, install his functions and then look at
Interior Color, using Count, SUM, etc. (#count)
http://www.mvps.org/dmcritchie/excel/colors.htm#count

If not familiar with installing and using Macros or User Defined Functions see
http://www.mvps.org/dmcritchie/excel....htm#havemacro

Macros and User Defined Functions are installed in the same manner.-

BTW, colors derived from Conditional Formatting require additional
coding. If the color is from C.F. you should be using the same formulas
rather than looking at color. Needless to say arithmetic based on color
is not very efficient.

--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Toky" wrote in message ...
Is there a formula for counting items that have been marked in a certain color?