copy format cell and its content via formula

[spilner]

hi,is it possible to copy a format cell and its content?

in G11,i have it bold and italic.

example in other sheet's cell ='207'!G11

this formula just copy the content on G11 but without the bold and italic or colour.

is there anyway i can do this?

thanks mr.excel

 

[VoG]

Sorry, a formula cannot format a cell.