View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
tjtjjtjt
 
Posts: n/a
Default Counting cells according to their colour

You will have to use a UDF. See these sites for details:


http://www.xldynamic.com/source/xld.ColourCounter.html
http://www.cpearson.com/excel/CFColors.htm

--
tj


"ALawes" wrote:

How can I count cells according to their fill colour, regardless of their
actual content?

ALawes