I assume that you have formatted the cell on sheet1 the way you want it
(red font strike though etc). Copy this cell and go to the mastersheet
and select PASTE SPECIAL. Select FORMAT and then set the cell to look
at the other cell on worksheet1 (something like =+worksheet1!a21)

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=401839