View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.