Is there a formula for counting items that have been marked in a certain color?
Is there a formula for counting items that have been marked 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?
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?
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" <[email protected]> wrote in message news:[email protected]...
> Is there a formula for counting items that have been marked in a certain color?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks