Copy the range and Paste SpecialLinks.

Then Paste SpecialFormats.


Gord Dibben Excel MVP

On Tue, 8 Feb 2005 15:47:02 -0800, Benfanfromlo
wrote:

I am trying to copy cells that have conditional formatting to another
worksheet within the same workbook. I would like to preserve the formatting
but I can only link the data. Is there a method for maintaining the
conditional formatting from the original tab through the link?