Chip Pearson has a function on his site to do exactly that:

http://www.cpearson.com/excel/colors.htm

=CountbyColor()


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=554973