Copying cells with conditional formatting

B

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?
 
G

Gord Dibben

Copy the range and Paste Special>Links.

Then Paste Special>Formats.


Gord Dibben Excel MVP
 
B

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?
 
G

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
 
Top