T
Toky
Is there a formula for counting items that have been marked in a certain color?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
deflated
i seriously doubt it.
M
Michael
Hi Toky. Try Chip Pearson's site at:
http://www.cpearson.com/excel/colors.htm. HTH
http://www.cpearson.com/excel/colors.htm. HTH
D
David McRitchie
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/getstarted.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.
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/getstarted.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.