Sumif

F

Fk

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

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
 
F

Fk

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
 
Top