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.
--
HTH...

Jim Thomlinson


"kefee85" wrote:

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

"Gary''s Student" wrote:

The link formulas in the master return only the values, not the formats.
Copy the source cells and pasteSpecial format onto the master cells.
--
Gary''s Student - gsnu200835


"kefee85" wrote:

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?