I have 2 worksheet.

The first worksheet1 Cell e.g. A2 have formating such as "What a good day"
with "What" in Red color, "a good day" in Green color and entire word in Bold.

On 2nd worksheet2, I put " =worksheet1!A2 ". The result only the words but
without the formating.

Please help how can I display exactly the same in 2nd worksheet with 1st
worksheet including all the formating?

--
Thanks a lot.

Best Regards,
Garry Khoo