Copying cells with conditional formatting

[Benfanfromlo]

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?

[Gord Dibben]

Copy the range and Paste Special>Links.

Then Paste Special>Formats.


Gord Dibben Excel MVP

On Tue, 8 Feb 2005 15:47:02 -0800, Benfanfromlo
<[email protected]> 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?

[Benfanfromlo]

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 Special>Links.
>
> Then Paste Special>Formats.
>
>
> Gord Dibben Excel MVP
>
> On Tue, 8 Feb 2005 15:47:02 -0800, Benfanfromlo
> <[email protected]> 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?
>
>

[Gord Dibben]

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
<[email protected]> 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 Special>Links.
>>
>> Then Paste Special>Formats.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 8 Feb 2005 15:47:02 -0800, Benfanfromlo
>> <[email protected]> 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?
>>
>>