Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Colors of Cells set by Conditional Formatting | Excel Worksheet Functions | |||
How to conditional format in 3 colors in 2007 | Excel Discussion (Misc queries) | |||
Copy conditional format colors to another cell | Excel Programming | |||
colors and conditional format - greater than, less than | Excel Discussion (Misc queries) | |||
Cell colors on conditional format | Excel Discussion (Misc queries) |