Seems to me that you do want to count by colour but you are counting
every instance of white in a range.......................you can get
all the code and help you need
here....http://www.cpearson.com/excel/colors.htm loads of great help
here with worked examples!

HTH

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=471707