On Apr 25, 1:44*pm, 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 :)