View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Countifs for color format

Your answer is he
http://www.cpearson.com/excel/CFColors.htm


This is good too:
http://www.cpearson.com/excel/colors.aspx

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Doug" wrote:

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"