View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Is there an Excel formula to sum color filled cells?

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alfred Kingfisher" <Alfred wrote in
message ...
I have an Excel (2003) worksheet where cells are either color filled or

not.
Is there a formula that I can use to calculate the current number of cells
that have no color fill?