You can use a conditional format in sheet 2 to match sheet 1

Put this into the conditional formating in sheet2!A2
=Sheet1!A1321=A2

Now once you setup the conditional formating in sheet 2 you can copy
the cells from sheet 1 without destroying the conditional formating by
copy and pastespecial using both values, and Transpose

Sheets("Sheet1").Range("A2:G7").Copy
Sheets("Sheet2").Range("A2").PasteSpecial _
Paste:=xlPasteFormats, _
Transpose:=True


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148967