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.