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

See if Chip Pearson doesn't have some help for you here:
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.

"(E-Mail Removed)" 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
>
>