ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   keeping text format in linked cells (https://www.excelbanter.com/excel-worksheet-functions/189152-keeping-text-format-linked-cells.html)

carourke

keeping text format in linked cells
 
I am trying to keep the format of the original cell when I link it to another
workbook. There are several employee names, one employee name per cell, all
cells are linked to another workbook. One week the name john doe will be
changed to BOLD text in the original workbook, which will need to be
reflected in the linked workbook, The next week, Becky Sue Smith's name will
be changed to bold in the original workbook and the change in text will have
to be shown in the linked workbook.

Gary''s Student

keeping text format in linked cells
 
Linked cells return only the value and not the format.
--
Gary''s Student - gsnu200789


"carourke" wrote:

I am trying to keep the format of the original cell when I link it to another
workbook. There are several employee names, one employee name per cell, all
cells are linked to another workbook. One week the name john doe will be
changed to BOLD text in the original workbook, which will need to be
reflected in the linked workbook, The next week, Becky Sue Smith's name will
be changed to bold in the original workbook and the change in text will have
to be shown in the linked workbook.



All times are GMT +1. The time now is 02:36 PM.

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