Ok, try this formula in Conditional Formatting:
=COUNTIF($A$1:$C$3,A1)<1

HTH
Ola Sandström


Note:
Zip-file:
http://www.excelforum.com/attachment...tid=3517&stc=1
Video:
http://www.datapigtechnologies.com/f...rmatexcel.html


+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3517 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=380395