Sumif

[Guest]

Can cell be totaled (added together) using the backround color as the
criteria for choosing the cells in a sumif command? Example, add all cells
with the red backround color.

 

[T. Valko]

See this:

http://cpearson.com/excel/colors.htm

In my opinion, you're better off using the logic of why the cells are a
certain color to construct a formula with the built-in functions. For
example, the cells are red because the values are less than 100. Then it
could be as easy as:

=SUMIF(A1:A10,"<100")

Biff

 

[Guest]

The color of the cell and the value of the cell aren't related. I also need
to know where can get the numerical value of the cell colors.

Thanks

 

[T. Valko]

That's covered at the link. Look for: Returning The ColorIndex Of A Cell

Biff