When linking cells from spreadsheets together how do you bring the formatting
of those cells across to the linked spreadsheets. For example how would you
bring the fill color across to all the linked cells?

Check your other post.

Al wrote:

When linking cells from spreadsheets together how do you bring the formatting
of those cells across to the linked spreadsheets. For example how would you
bring the fill color across to all the linked cells?

--

Dave Peterson

Linking formulas return values only.

If the fill color of source cells is due to Conditional Formatting you can
set the the CF conditions on the Destination cells.


Gord Dibben MS Excel MVP

On Tue, 8 Sep 2009 13:27:31 -0700, Al wrote:

When linking cells from spreadsheets together how do you bring the formatting
of those cells across to the linked spreadsheets. For example how would you
bring the fill color across to all the linked cells?