Color in Linked Worksheets

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

I have multiple worksheets linked to 1 worksheet within
the same workbook. The numbers carry over fine, but the
background colors don't. I know you can use "copy/paste
special --> format" to carry over the color. But if I
change the color in the original cell that is linked to
other cell, the color doesn't automatically change. Help!
 
Rachel,

You can't link formatting. You can use event code to copy over the
formatting, but it would may not be worth the effort.

HTH,
Bernie
MS Excel MVP
 
Back
Top