Thanks for the spot. Someone did tell me about that once before, but I
forgot the details, so didn't correct it ... will do now.

Okay, so back to the issue.

I installed this function, made that correction, and changed values in my
range, and the formula cell updated correctly. So it is not your correction
that is causing the problem, it must be something else in your setup.

--
---
HTH

Bob


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



"mwam423" wrote in message
...
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.