I edited the post earlier after realising what you needed. Just paste
the values normally, then use the macro vba i posted above to clean the
conditional formatting up. 2 step process ^^


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544293