linking and formatting

  • Thread starter Thread starter jgrenier1231
  • Start date Start date
J

jgrenier1231

I am able to link cells from worksheet to worksheet with the exception
of the fomatting. I'm trying to create a master worksheet by updating
specific individual worksheets. However I can't get the colors or
comments to link. Please help.
 
J,

Linking yields the value from the linked cell, but not the formatting. If
the formatting was applied via conditional formatting in the source cell,
you could use the same conditional formatting in the linking cell.
Otherwise, you'll have to use a macro to retrieve the formatting and apply
it, and the target file will have to be open, unlike with linking.
 
Back
Top