Have a look here: http://cpearson.com/excel/colors.htm Biff
B Bob Phillips Jan 2, 2005 #3 There is also a complete solution at http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH RP (remove nothere from the email address if mailing direct)
There is also a complete solution at http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH RP (remove nothere from the email address if mailing direct)