wanted to point out possible error in code shown in figure 8 of the white
paper:

CFColorCount = CFColorCount - _
CLng(CFColorindex(cell, text) )= ciValue)

kept getting error so changed second line, removing the second parenthesis
after "text":

CLng(CFColorindex(cell, text) = ciValue)

this seemingly works, or could this be causing recalc problem? otherwise
the code is exactly what's in your white paper . .

"Bob Phillips" wrote:

I have just tried this now with a range of 20 numbers, and two conditions.

Using the two functions, CFColorindex, and CFArrayColours, I got the
expected results. I then changed a value so that it became formatted, and
the formula cell updated correctly.

So, it is working here.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mwam423" wrote in message
...
hi bob, am using your CFcolorcount formula over multiple ranges and while
it
gets me good values when typed in, i can't seem to get the formula to
update
when there is change in data, which results in change in conditional
format.

has anyone else run into this problem? any help greatly appreciated.
fyi,
this function is a godsend(!) as you got around the requirement of having
fixed values in the conditional formula.