Copying cells with conditional formatting
 

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?

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?

I need to be able to link to a changing format. While this does work for a
one-time approach, I am working with about 100 fields and need to be able to
dynamically update the formats on a seperate page without having to replicate
the conditional formatting. Any ideas?

"Gord Dibben" wrote:

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?

Unfortunately, linking does not carry the formatting over with it.

You will have to copy over the formatting somehow.

Either manually or through code.

Visit the microsoft.public.excel.programming group for ideas on code if you
want to go that route.


Gord

On Thu, 10 Feb 2005 02:59:01 -0800, Benfanfromlo
wrote:

I need to be able to link to a changing format. While this does work for a
one-time approach, I am working with about 100 fields and need to be able to
dynamically update the formats on a seperate page without having to replicate
the conditional formatting. Any ideas?

"Gord Dibben" wrote:

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?