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.

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" <(E-Mail Removed)> wrote in message
news:C106F927-325B-42C3-8C61-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
> news:C106F927-325B-42C3-8C61-(E-Mail Removed)...
> > 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.
>
>
>

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" <(E-Mail Removed)> wrote in message
news:55522C68-E1B0-4B7A-83F4-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:C106F927-325B-42C3-8C61-(E-Mail Removed)...
>> > 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.
>>
>>
>>

could you be alittle more specific regarding setup, i'm not clear what that
means.

i've tried deleting code and copying code directly from white paper. this
has actually caused different problem. i get a compile error: wrong number
of arguments which highlights CFcolorindex function in CFcolorcount code. if
i remove the ", text" after rng and cell, in closed parentheses, it seems to
work (does this make sense? ) but still have the same problem described above.
namely, the CFcolorcount function does not update when i repeatedly hit F9,
or when running macro using "calculate". only recalcs when i goto cell, hit
F2, then hit Enter.

weird thing is, when i did pretty much the exact same thing, the first time,
i.e. copy code from white paper to module, didn't get the compile error . .
as you can see i'm lost here. any ideas?

"Bob Phillips" wrote:

> 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.
>

I have posted an example at

http://cjoint.com/?fEu323LkCx

--
---
HTH

Bob


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



"mwam423" <(E-Mail Removed)> wrote in message
news:496B9A08-D4A1-4038-AEE7-(E-Mail Removed)...
> could you be alittle more specific regarding setup, i'm not clear what
> that
> means.
>
> i've tried deleting code and copying code directly from white paper. this
> has actually caused different problem. i get a compile error: wrong
> number
> of arguments which highlights CFcolorindex function in CFcolorcount code.
> if
> i remove the ", text" after rng and cell, in closed parentheses, it seems
> to
> work (does this make sense? ) but still have the same problem described
> above.
> namely, the CFcolorcount function does not update when i repeatedly hit
> F9,
> or when running macro using "calculate". only recalcs when i goto cell,
> hit
> F2, then hit Enter.
>
> weird thing is, when i did pretty much the exact same thing, the first
> time,
> i.e. copy code from white paper to module, didn't get the compile error .
> .
> as you can see i'm lost here. any ideas?
>
> "Bob Phillips" wrote:
>
>> 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.
>>
>

hi bob, i'll take a look, thanks and have a great weekend

hi bob, i've recreated what's happening in my model. in cell A22 put in
formula: =A23*A24; A23, =rand(); A24, 50 (or a number)

change conditional format in A1 as follows: condition 1, formula: =a1>A$22;
delete condition 2, then copy "format-only" down to A20.

change value in A24. as value in A22 changes, color format in A1 through
A20 will change, however value in E5 doesn't reflect change. let me know if
you have any questions, comments, thanks

On May 31, 4:24*am, mwam423 <mwam...@discussions.microsoft.com> wrote:
> hi bob, i've recreated what's happening in my model. *in cell A22 put in
> formula: =A23*A24; A23, =rand(); A24, 50 (or a number)
>
> change conditional format in A1 as follows: condition 1, formula: =a1>A$22;
> delete condition 2, then copy "format-only" down to A20.
>
> change value in A24. *as value in A22 changes, color format in A1 through
> A20 will change, however value in E5 doesn't reflect change. *let me know if
> you have any questions, comments, thanks

Sorry to intrupt in between, but can you pl let me know where these
coler functions are available
and possibly any write-up for the same?

Regards,
Madiya

Hi Madiya,

Visit Bob's xlDynamic Site:

http://www.xldynamic.com/source/xld.html


More particularly, see Bob's

Testing CF Conditions page at:
http://www.xldynamic.com/source/xld.CFConditions.html



---
Regards.
Norman


"Madiya" <(E-Mail Removed)> wrote in message
news:c6870f83-64cd-418e-ac0f-(E-Mail Removed)...
On May 31, 4:24 am, mwam423 <mwam...@discussions.microsoft.com> wrote:
> hi bob, i've recreated what's happening in my model. in cell A22 put in
> formula: =A23*A24; A23, =rand(); A24, 50 (or a number)
>
> change conditional format in A1 as follows: condition 1, formula:
> =a1>A$22;
> delete condition 2, then copy "format-only" down to A20.
>
> change value in A24. as value in A22 changes, color format in A1 through
> A20 will change, however value in E5 doesn't reflect change. let me know
> if
> you have any questions, comments, thanks

Sorry to intrupt in between, but can you pl let me know where these
coler functions are available
and possibly any write-up for the same?

Regards,
Madiya