Hi Wazooli
Unfortunately, the answer Bernie gave you is correct, regardless of the
colour of the cells.
However, you could look at using a colour index Macro that will allow you to
Count and Sum all of your coloured cells.
You can find this at
www.xldynamic.com/source/xld.ColourCounter.html
Be warned though, this won't work with conditional formatted cells. So you
will have to remove the conditional formats.

HTH
Michael

"Wazooli" wrote:

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