formatting

[kizzie37]

Not sure if this is possible. When referencing cells from one sheet in a workbook to antoher shet, is it possible to keep the formatting from the original sheet, not using conditional format.

i.e if the person markes the cell in the orig sheet with strikethrough or a colour, can the referenced cell on the other sheet follow suit?.

am using excel 2007

 

[Smitty]

It's possible with a Calculate or Change or event, but probably not entirely practical (especially in the case of the former).