It was suggested that I post this question to the Excel Programming group ...

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?