In the interest of full disclosure I know absolutly nothing about VB.

I'm using the code from: http://www.xldynamic.com/source/xld.CFConditions.html

I'm using 3 conditions:

1) Cell Value >= .99 shades cell green
2) Cell Value Between .99 and .9 shades cell yellow
3) Cell Value <= .9 shades cell red

Now, the problem that I'm having is that I can't get the yellow shaded
cells counted using the supplied code from that site. I've tried
taking it one step at a time and have come to find out that according
to the IsCFMet1 function from that site reports FALSE if a condition
is met on only the cells shaded in yellow. That leads me to belive
that there's something wrong with my second condition that's set up,
but what that may be I have no idea. Any ideas/suggestions?

Thanks in advance,
Destrachan

On Apr 25, 1:44*pm, Destrac...@gmail.com wrote:
> In the interest of full disclosure I know absolutly nothing about VB.
>
> I'm using the code from:http://www.xldynamic.com/source/xld.CFConditions.html
>
> I'm using 3 conditions:
>
> 1) Cell Value >= .99 shades cell green
> 2) Cell Value Between .99 and .9 shades cell yellow
> 3) Cell Value <= .9 shades cell red
>
> Now, the problem that I'm having is that I can't get the yellow shaded
> cells counted using the supplied code from that site. *I've tried
> taking it one step at a time and have come to find out that according
> to the IsCFMet1 function from that site reports FALSE if a condition
> is met on only the cells shaded in yellow. *That leads me to belive
> that there's something wrong with my second condition that's set up,
> but what that may be I have no idea. *Any ideas/suggestions?
>
> Thanks in advance,
> Destrachan

Nevermind, I decided to "inspect" the VB code as best I could and
through the power of deductive reasoning found that in the IsCFMet1
code there's a mix up with the >= & <= in regards to the between
argument. All's well now

Can you clarify that please, I am not aware of it?

--
---
HTH

Bob


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



<(E-Mail Removed)> wrote in message
news:9917ac51-eccd-469d-aa1b-(E-Mail Removed)...
On Apr 25, 1:44 pm, Destrac...@gmail.com wrote:
> In the interest of full disclosure I know absolutly nothing about VB.
>
> I'm using the code
> from:http://www.xldynamic.com/source/xld.CFConditions.html
>
> I'm using 3 conditions:
>
> 1) Cell Value >= .99 shades cell green
> 2) Cell Value Between .99 and .9 shades cell yellow
> 3) Cell Value <= .9 shades cell red
>
> Now, the problem that I'm having is that I can't get the yellow shaded
> cells counted using the supplied code from that site. I've tried
> taking it one step at a time and have come to find out that according
> to the IsCFMet1 function from that site reports FALSE if a condition
> is met on only the cells shaded in yellow. That leads me to belive
> that there's something wrong with my second condition that's set up,
> but what that may be I have no idea. Any ideas/suggestions?
>
> Thanks in advance,
> Destrachan

Nevermind, I decided to "inspect" the VB code as best I could and
through the power of deductive reasoning found that in the IsCFMet1
code there's a mix up with the >= & <= in regards to the between
argument. All's well now

Case xlBetween
IsCFMet1 = (rng.Value >= oFC.Formula1 And _
rng.Value <= oFC.Formula2)

is what I'm referring to. But upon further review, it's really a "no
fault" error.
My second conditon looks like this: Cell Value Between .99 and .9
shades cell yellow.

So, I just had to change the order of the >= & <= from the way that
your originally wrote it. Of course I could have changed my condition
to read: Cell Value Between .9 and .99 shades cell yellow, instead but
I didn't really think about that at the time. I want to thank you
Bob, the code that you put up is wonderful and once I finally got my
brain wrapped about it a bit, it worked like a charm.

On Apr 25, 2:34*pm, "Bob Phillips" <bob....@somewhere.com> wrote:
> Can you clarify that please, I am not aware of it?
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> <Destrac...@gmail.com> wrote in message
>
> news:9917ac51-eccd-469d-aa1b-(E-Mail Removed)...
> On Apr 25, 1:44 pm, Destrac...@gmail.com wrote:
>
>
>
>
>
> > In the interest of full disclosure I know absolutly nothing about VB.
>
> > I'm using the code
> > from:http://www.xldynamic.com/source/xld.CFConditions.html
>
> > I'm using 3 conditions:
>
> > 1) Cell Value >= .99 shades cell green
> > 2) Cell Value Between .99 and .9 shades cell yellow
> > 3) Cell Value <= .9 shades cell red
>
> > Now, the problem that I'm having is that I can't get the yellow shaded
> > cells counted using the supplied code from that site. I've tried
> > taking it one step at a time and have come to find out that according
> > to the IsCFMet1 function from that site reports FALSE if a condition
> > is met on only the cells shaded in yellow. That leads me to belive
> > that there's something wrong with my second condition that's set up,
> > but what that may be I have no idea. Any ideas/suggestions?
>
> > Thanks in advance,
> > Destrachan
>
> Nevermind, I decided to "inspect" the VB code as best I could and
> through the power of deductive reasoning found that in the IsCFMet1
> code there's a mix up with the >= & <= in regards to the between
> argument. *All's well now - Hide quoted text -
>
> - Show quoted text -

Thanks for clarifying that. I will check out the code and see if I can make
work regardless of how the conditions are setup.

--
---
HTH

Bob


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



<(E-Mail Removed)> wrote in message
news:8ec5693d-e102-4ed2-9799-(E-Mail Removed)...
Case xlBetween
IsCFMet1 = (rng.Value >= oFC.Formula1 And _
rng.Value <= oFC.Formula2)

is what I'm referring to. But upon further review, it's really a "no
fault" error.
My second conditon looks like this: Cell Value Between .99 and .9
shades cell yellow.

So, I just had to change the order of the >= & <= from the way that
your originally wrote it. Of course I could have changed my condition
to read: Cell Value Between .9 and .99 shades cell yellow, instead but
I didn't really think about that at the time. I want to thank you
Bob, the code that you put up is wonderful and once I finally got my
brain wrapped about it a bit, it worked like a charm.

On Apr 25, 2:34 pm, "Bob Phillips" <bob....@somewhere.com> wrote:
> Can you clarify that please, I am not aware of it?
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
> <Destrac...@gmail.com> wrote in message
>
> news:9917ac51-eccd-469d-aa1b-(E-Mail Removed)...
> On Apr 25, 1:44 pm, Destrac...@gmail.com wrote:
>
>
>
>
>
> > In the interest of full disclosure I know absolutly nothing about VB.
>
> > I'm using the code
> > from:http://www.xldynamic.com/source/xld.CFConditions.html
>
> > I'm using 3 conditions:
>
> > 1) Cell Value >= .99 shades cell green
> > 2) Cell Value Between .99 and .9 shades cell yellow
> > 3) Cell Value <= .9 shades cell red
>
> > Now, the problem that I'm having is that I can't get the yellow shaded
> > cells counted using the supplied code from that site. I've tried
> > taking it one step at a time and have come to find out that according
> > to the IsCFMet1 function from that site reports FALSE if a condition
> > is met on only the cells shaded in yellow. That leads me to belive
> > that there's something wrong with my second condition that's set up,
> > but what that may be I have no idea. Any ideas/suggestions?
>
> > Thanks in advance,
> > Destrachan
>
> Nevermind, I decided to "inspect" the VB code as best I could and
> through the power of deductive reasoning found that in the IsCFMet1
> code there's a mix up with the >= & <= in regards to the between
> argument. All's well now - Hide quoted text -
>
> - Show quoted text -