You will not be able to do that with worksheet functions; will have to
develop a macro which does this using the color index.

If this post helps click Yes
---------------
Jacob Skaria


"akantrow2" wrote:

Hi -
I would like to know how to make certain cells one color, other cells
another color, then sum those cells based on their color. Could someone
assist me on how to do that?
I'm using office 2007.
thank you!