On Mon, 19 Sep 2005 00:42:03 -0700, GarryKhoo
wrote:

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?


The help suggests that conditional formatting can't be made dependent
on other worksheets or workbooks. Probably the only way to achieve
this is with a VBA macro

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________