I manually set certain colors on certain cells. then I re sorted them. But
I still want the sum of the colors I set.

"T. Valko" wrote:

Why are some numbers green and some red?

Write the formula based on *why* the numbers are the color they are.

--
Biff
Microsoft Excel MVP


"Rooky228" wrote in message
...
I have a column of numbers - some with different colors. I'd like to sum
just the green or the red, etc. How do I write a formula that somes only
certain colors?

Thanks,
Curt