Thread: ASAP Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
help help is offline
external usenet poster
 
Posts: 67
Default ASAP Function

I am trying to count and cells that have a number "11" in the cell and is
colored red.
The following formula, will count all cells that are red... but I only want
it to look at the cells with the "11". How do I do that?

=ASAPCountByFontColor(E5:E17,3)

Jane.