returning format from another spreadsheet

K

kefee85

I have a master calender spreadsheet that references three department
calender spreadsheets. I would like to master to reflect the format of the
cell it references, not just the value. Any ideas?
 
G

Gary''s Student

The link formulas in the master return only the values, not the formats.
Copy the source cells and pasteSpecial format onto the master cells.
 
K

kefee85

Unfortunately I can't cut and paste special since the cell is dynamic and the
master needs to reflect the change. Any other ideas?
 
J

Jim Thomlinson

There is no easy way to do what you have asked. Even using macros what you
want to do is a bit tricky as changing a format does not trigger an event so
there is no easy way to react to the change.
 
Top