Thanks Pete,

I was afraid that it wasn't possible. I looked as if the formatting was lost after the formula reference.

To offer more explaination in hopes that there is code out there that can assist me.

I have 3 worksheets within one workbook.

Sheet 1 we'll call the "final_sheet". This is the final report that I print out. It has all the colors and borders and cell ocation where I want them for printing purposes. All the cells have a reference located in them that points to sheet 2 (reference sheet). An example of the formula contained within sheet 1:
=reference_sheet!$C3

Sheet 2 we'll call the "reference_sheet". This sheet only has the indirect references. An example of the formula is: =INDIRECT("data!C3")

Sheet 3 we'll call the "data" sheet. The data sheet has the accual writen text that I want to have appear in the Final Sheet 1.

The text in the Data sheet (3) is always the same (unless I want it changed) but the location where I want that text to appear in the Final Sheet (1) is always changing. Due to my indirect cell referencing, I can move the data in the Data (3) sheet and have that text change location in the Final Sheet (1). I can have this text moved without having to recreate the Final Sheet (1) or re inserting new cell references.

I'd like to format the text in the Data (3) sheet (bold, italic, etc) and have that formatting appear in the final sheet. I cannot format the Final Sheet (1) because the information (text) will always be in a diffrent location within the final sheet (1).

If a formula cannot transmit formatting then I am supposing this formating change cannot be done. If anyone knows how to make a macro that can do this I would be very interested to learn.

Thank you in advance for any assistance,

Vaughan