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?