See if Chip Pearson doesn't have some help for you he
http://www.cpearson.com/excel/colors.htm

But it may also be possible to deal with things based, just as the colors
are, on their position on the sheet. So perhaps a little more information
about that might provide a color-independent solution? Maybe not.

" wrote:

Hello,

I have an Excel table where I have highlighted certain values
throughout the table by changing the cell font color and background
fill. I would like to find a way to determine the sum of all of the
values of the cells that I've highlighted.

And unfortunatley, the coloring is based on position, not value, so I
can't use a trick like SUMIF.

Thanks!

-Ben