Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatted cells on summary worksheet
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summary data sheet from worksheet to worksheet | Excel Worksheet Functions | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
Across a worksheet, which cells I have formatted as locked? | Excel Worksheet Functions | |||
copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |