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