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.