Hi =?Utf-8?B?SnVzdGlu?=,

We have an Excel spread sheet that contains conditional formatting (red strike
outs, highlighted cells with bolded text) being used as a data source. We have a
Word document that has been mail merged to the above mentioned spread sheet and
contains a chart displaying the data, currently with out the conditional
formatting. We'd like to have the associated conditional formatting carry across
from the spread sheet to the Word document during the mail merge. Is this possible
in Word XP or Word 2003, if so can you please tell me how?

Between Excel and Word, no, it's not possible. But there is a way to do it, if your
table has 63 columns or less:

1. Copy the table in Excel

2. Paste into a new, empty Word document (with or without a link); the formatting
should be retained?

3. Save (and close)

4. Now select this document as the data source

5. Insert all the merge fields (you won't see the formatting, yet!)

6. Press Alt+F9 to display the field codes. Remove the term Mergefield from the
merge fields where the formatting should come across. (Note: you MUST have at least
ONE Mergefield in the merge document or you can't execute the merge)

7. Alt+F9 again, and try merging.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)