ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link Cell Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/144699-link-cell-formatting.html)

[email protected]

Link Cell Formatting
 
In a workbook that I have there are several sheets of information and
some parts of the sheets are connected to Sheet 1 so that any changes
that are made on Sheet 1 are updated on the following sheets. Is
there anyway to link the cell formatting as well so that if the font
is changed in Sheet 1 it is also changed on the following sheets?

David Swiderski


Gord Dibben

Link Cell Formatting
 
Not without some type of event code.


Gord Dibben MS Excel MVP

On 31 May 2007 08:33:15 -0700, wrote:

In a workbook that I have there are several sheets of information and
some parts of the sheets are connected to Sheet 1 so that any changes
that are made on Sheet 1 are updated on the following sheets. Is
there anyway to link the cell formatting as well so that if the font
is changed in Sheet 1 it is also changed on the following sheets?

David Swiderski




All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com