Hi Does anyone know if it is possible to type text into a cell on sheet 1 and it be reproduced in another cell on sheet 2 and keep the formatting. i.e. the first word is in bold and then the following 10 words are not bold. I have managed to duplicate the text but not the formatting using ='Sheet One'!A1 but I can not get the formatting to stay the same. Any help greatly appreciated :-)
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of July 01, 2014.