copy formatted (red font) cells from one worksheet to another
 

How do the result displayed and updated in a cell on 'worksheet 1' mirror or
copy the red font color (and strike through) of a cell on a seperate
worksheet automatically? - 'worksheet 2'?

on worksheet 1 it is currently black, but when I cross it off (red font and
strike through) - I want it to update this action / result to a master list
so that I dont have to update both worksheets.

thanks.

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