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 :)