COUNTING BASED ON CONDITIONAL FORMAT?
 

I have data that has been conditionally formatted into 2 colors (red and
green). Is there a way to count the data that is green in a row? There is no
other "like" characteristics of all the data except that they are now
conditionally green.

COUNTING BASED ON CONDITIONAL FORMAT?
 

Can't you use the same condition that you used to do the conditional
formatting?
--
David Biddulph

"jasonhelpme" wrote in message
...
I have data that has been conditionally formatted into 2 colors (red and
green). Is there a way to count the data that is green in a row? There is
no
other "like" characteristics of all the data except that they are now
conditionally green.

COUNTING BASED ON CONDITIONAL FORMAT?
 

Certainly there must be some like characteristics that cause them to be
green.

--

"jasonhelpme" wrote in message
...
I have data that has been conditionally formatted into 2 colors (red and
green). Is there a way to count the data that is green in a row? There is
no
other "like" characteristics of all the data except that they are now
conditionally green.

COUNTING BASED ON CONDITIONAL FORMAT?
 

On Mon, 31 Dec 2007 13:53:00 -0800, jasonhelpme
wrote:

I have data that has been conditionally formatted into 2 colors (red and
green). Is there a way to count the data that is green in a row? There is no
other "like" characteristics of all the data except that they are now
conditionally green.

You need to count based on the conditional formatting formula.
--ron

COUNTING BASED ON CONDITIONAL FORMAT?
 

See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob


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



"jasonhelpme" wrote in message
...
I have data that has been conditionally formatted into 2 colors (red and
green). Is there a way to count the data that is green in a row? There is
no
other "like" characteristics of all the data except that they are now
conditionally green.