I am using a 2007 workbook as a Training schedule for a military command. I
deal with various different military units and in order to quickly tell which
is which they are color coded with specific fill colors. Normally the units
will copy my spreadsheet and place their information at the bottom for their
individual use. So to correct that, I liked my master schedule workbook
(source) to a another workbook (destination) that they can use so that when I
make changes, the top part of their schedule will be updated. Everything
works perfect except the "cell fill color" The destination workbook will
immediately show the text, but no fill color at all? Does anyone know if its
possible to have the fill color reflected on the destination workbook as
well? In edit paste special, I have "ALL" checked so it should transfer over
cell formatting as well.

Thank you,
Scott

Only values are transferred from linked cells.


Gord Dibben MS Excel MVP

On Tue, 11 May 2010 13:34:01 -0700, Scott
wrote:

I am using a 2007 workbook as a Training schedule for a military command. I
deal with various different military units and in order to quickly tell which
is which they are color coded with specific fill colors. Normally the units
will copy my spreadsheet and place their information at the bottom for their
individual use. So to correct that, I liked my master schedule workbook
(source) to a another workbook (destination) that they can use so that when I
make changes, the top part of their schedule will be updated. Everything
works perfect except the "cell fill color" The destination workbook will
immediately show the text, but no fill color at all? Does anyone know if its
possible to have the fill color reflected on the destination workbook as
well? In edit paste special, I have "ALL" checked so it should transfer over
cell formatting as well.

Thank you,
Scott