how can I merge print and keep the conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob M - 14 Dec 2004 01:45 GMT

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

Reply to this Message

Cindy M -WordMVP- - 15 Dec 2004 14:32 GMT

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.

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 :-)

Reply to this Message