Is there a way to display everything from one cell in a cell on another sheet?

[jacklondon]

I know it's easy to display the contents of a cell in another sheet by using, for example, a forumla like this:

='Sheet 1'!J30

But I was wondering if there is a way to display everything from the cell (the fill, the colour of the text etc as well as the actual numeric value in the cell)

Many thanks,

Jack

[InvisibleMan]

Short answer: no

[jacklondon]

Thanks for answering so quickly - I guess it would need to be done with conditional formatting?