View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Countifs for color format

I have columns AA through AK that are conditionally formatted to either a red
fill or a green fill.
How can I enter countifs in a column to tell me how many Green fills there
are in a given row.

So if for a particular row only column AA has a green and AD has a green, it
will tell me "2"