View Single Post
  #2   Report Post  
Old February 26th 13, 09:25 AM
Gizzmo Gizzmo is offline
Junior Member
 
First recorded activity by ExcelBanter: Feb 2013
Posts: 20
Default

Quote:
Originally Posted by shriil View Post
Hi

I would like to create and run a function that Sums or counts cells based on a specified fill color, for e.g. say i have a green fill in Cell B1 and I have different fill colours in Range (A1:A10)

I would like to know how many cells in (A1:A10) have the same green fill as in Cell B1

Thanks

San
See the attached file code has been sourced from http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Hope this helps
Attached Files
File Type: zip OzGridSumCount.zip (14.7 KB, 35 views)