Copying cell fills, formats and values
Posted by Tony Harvey on September 14, 2000 6:13 PM
I have a master sheet which displays text values
in cells. The cells are colour coded also.
I need to link the master sheet to some slave sheets
so that when the text value of fill colour changes in
the master sheet it automatically changes in the slave
sheets
I've tried paste link and can get formulas or values
to change but not the fill colour.
HELP! It's driving me crazy, I'm sure the answer is
simple and under my nose!
Cheers,
Tony