View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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