Wazooli

Chip Pearson has code for determining the CF colors based on the condition(s)
input.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 14:07:03 -0800, "Michael"
wrote:

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