View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
simonfothers simonfothers is offline
external usenet poster
 
Posts: 1
Default using COUNTIF for cells that are coloured

Needing to produce a formula that counts cells that provide a result that is
0 but <3, AND also only those that are shaded Orange in addition to the

values.

Is there a way to count cells based on data as well as formatting, in this
case, cells that are coloured ?

thanks !