I'm not sure i totally follow you, but what if you changed the formula
in the conditional formatting window to...
=countif($d$1:$d$6,$A2)
(Added $ symbol in from of the A in "A2")
And applied this conditional format to each cell, column A, B, and C?
--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile:
http://www.excelforum.com/member.php...o&userid=26423
View this thread:
http://www.excelforum.com/showthread...hreadid=398935