Sumif
 

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.

Sumif
 

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

"Fk" wrote in message
...
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.

Sumif
 

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

"Fk" wrote:

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.

Sumif
 

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

Biff

"Fk" wrote in message
...
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

"Fk" wrote:

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.