Hi,

Don't give up quite yet...

Please give us more details, for example do you want to color the cells
based on their value and if so what are your condtions. Or are you coloring
cell at random based on nothing.

I think you can do what you want if you color coding is not random, but we
need to understand your rules.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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!