Made a mistake explaining. The cells on the left do not have conditional
formatting, they are just colored red manaully if they are negative. I
stil want the cells on the left that the links were poasted to be in
color if the corresponding cell on the left is colored. In other words,
I want to paste the link AND the color of the original cell.


--
bre
------------------------------------------------------------------------
bre's Profile: http://www.excelforum.com/member.php...o&userid=20765
View this thread: http://www.excelforum.com/showthread...hreadid=535323