To simplify I will explain as easy as possible what I'm in need of but within
the same file I have 2 work sheets (I'll call them A & B)

On worksheet A (which is basically just a summary sheet) I'm extracting
applicable data from worksheet B where all of my detailed sheduling is done
which is basically noise to the rest of the organization because all they
just want to see are the results without all the details.

So in worksheet A I'm going out to worksheet B and retrieving the result on
worksheet B if my conditions are being met (mainly using "If" statements).
On worksheet B I use different text formats to highlight changes or deletions
such as highlighting in red text, using strike through, maybe making the text
bold, etc...... but here is my problem:

When the data is pulled over onto worksheet A it always defulat to just
basic text format and I want it to carry over the exact text format as it
appears on worksheet B - again it is just the appearance and not for instance
how the date is represented such as 01/03/09 vs. 1/3/09 as I can fix that
condition easily.

Does anyone know if this can be done as my local very experienced partners
cannot figure it out.

Please help if you have suggestions!

Thanks