Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula for counting text in a certain color?
Is there a formula for counting items that have been marked in a certain color?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I sum color filled cells in Excel with no values or text? | Excel Discussion (Misc queries) | |||
Is there an Excel formula to sum color filled cells? | Excel Worksheet Functions | |||
Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |