I think he wants to count conditionally formatted colours, not just manually
formatted colours.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"michael.a7" wrote
in message ...

The following website might help
http://www.excelexchange.com/


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile:
http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=530528