wazooli,

Let's say that your table is in A1:F10. In H1, enter the formula
=MAX(A1:F1), and copy down to H2:H20.

Then in cell A11, use the formula
=SUMPRODUCT((A1:A10=$H$1:$H$10)*A1:A10)
and copy to B11:F11.

HTH,
Bernie
MS Excel MVP

"Wazooli" wrote in message
...
Is there as yet a workaround for this? I have a table of values, where
the
largest value in each row is colored thanks to conditional formatting. I
would like to be able to sum all the colored cells for each column using
the
.interior.colorindex property.

wazooli