ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   link cell format (https://www.excelbanter.com/excel-programming/273641-re-link-cell-format.html)

Dave Peterson[_3_]

link cell format
 
Not via formulas (linked cells).

You'd have to use some kind of macro that retreives the formatting from that
other workbook.

Another option might be to use format|conditional formatting. Maybe that'll be
enough.

wrote:

Hi,
In my program I generate an excel workbook with cells
linked to a "master" workbook using a simple formula
indicating the file name and cell. When I write something
in the master workbook, it works perfectly writing the
same contents to the linked workbook. However, if I
decide to make the text in the cell of the master workbook
bold, for example, this is not reflected in the linked
workbook. Is there anyway to link a cell, so that format
changes as well as value changes are reflected? Thanks a
lot in advance.

Joe.


--

Dave Peterson



All times are GMT +1. The time now is 09:18 PM.

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