View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Destrachan@gmail.com is offline
external usenet poster
 
Posts: 25
Default Counting Conditional Format colors

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