how can I merge print and keep the conditional formatting

B

Bob M

I want to print words that are color coded by conditional formatting in the
Excel spread sheet used to merge to a Word document.
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?Qm9iIE0=?=,
I want to print words that are color coded by conditional formatting in the
Excel spread sheet used to merge to a Word document.
Click to expand...
Unsupported.

Best you could do would be to copy/paste the table (with a link, if you like)
into a Word document so that Word preceives it as a Word table. Insert the
merge fields. Alt+F9 to view the field codes. Remove the word "Mergefield"
from those data fields where you need to bring across the font formatting.
Alt+F9 to hide the field codes. Execute the merge.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Excel --> Word 4
Page numbering with Merged Document and IF statements 1
Width of document changes when merging 1
Table of content - format does not get saved 2
Merging from an Excel file with graphics 1
Printing from Word my Inserted Pictures colors are dull and lack color 0
Merge Excel file into Word Document 3

Top