Copying a cell with conditional formatting doesn't work because the
conditional formatting isn't seen as 'constant'. So I won't change to
$b$3$a$3 ... $b$4$a$4 etc.etc.

Another solution maybe?

I've included a test file which better explains my problem.

3Pinter


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

--
3Pinter
------------------------------------------------------------------------
3Pinter's Profile: http://www.excelforum.com/member.php...o&userid=32623
View this thread: http://www.excelforum.com/showthread...hreadid=524256