Color in Linked Worksheets

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!
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carry over formatting between linked cells. 3
Cell fill color in linked cells? 1
Paste Values in linked Cells Only 4
Stop linked cells from changing when insert new row? 1
Linked cells between worksheets and sorting 2
HELP PLEASEEE!!! pulling color cell from workbook to linked workbo 1
pulling color from cell of workbook to another linked workbook 5
If Stmt using background color to evaluate 2

Top