Reply
 
Thread Tools Display Modes
  #1   Report Post  
Bob M
 
Posts: n/a
Default how can I merge print and keep the conditional formatting

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

  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 01:22 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"