COUNTING BASED ON CONDITIONAL FORMAT?

[jasonhelpme]

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.

 

[David Biddulph]

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

 

[PCLIVE]

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

 

[Ron Rosenfeld]

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

 

[Bob Phillips]

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)