View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default COUNT IF - Conditional Formatting

I need a formula for the following:

If Col D = SW and Col E = France, then count how many green cells are in Col
O. (Column O has conditional formatting of Green, Yellow & Red based on a %,
but I don't want to count the %, just want to count the instances of Green).

Thanks very much!