Copying cells with conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Special>Links.

Then Paste Special>Formats.


Gord Dibben Excel MVP
 
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
... I would like to link conditional formating to linked workbooks 2
Copy Conditional Formatting 1
Copying Conditional formatting 2
Conditional formatting overwritten with copy 3
Excel 2007 - A Conditional Formatting ?'s 1
Conditional Formatting 1

Back
Top