Ok, try this formula in Conditional Formatting:
=COUNTIF(OFFSET($A$3:$C$3,0,INT((COLUMN()-1)/3)*3),A3)<1
HTH
Ola Sandström
Note:
Zip-file:
http://www.excelforum.com/attachment...tid=3518&stc=1
Video:
http://www.datapigtechnologies.com/f...rmatexcel.html
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3518 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=380395