Thread: Count IF function for color/shading of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default Count IF function for color/shading of cells
You would have to create some VBA code. See here for an explanation:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Dave
--
Brevity is the soul of wit.


"Rick" wrote:

How do you count the number of cells with a fill color of green in a range of
cells?
Reply With QuoteReply With Quote