 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2006Conditional Formatting
I have an excel 2003 spreedsheet that I am using as a database in a Word 2003 mail merge. I have conditional formatting in the excel spreadsheet, basically when someone types in a R it changes the box to RED. Is there any way to do something similiar in the word table that stores the mail merge fields? It brings the R into the word table but not the color. Thanks for the help! I should also mention that I have attached the excel file as DDE. > I have an excel 2003 spreedsheet that I am using as a database in a Word 2003 > mail merge. I have conditional formatting in the excel spreadsheet, basically > when someone types in a R it changes the box to RED. Is there any way to do > something similiar in the word table that stores the mail merge fields? It > brings the R into the word table but not the color. Thanks for the help! You can't do this directly because Word has nothing that is the equivalent of Excel's conditional formatting. However, using the CharFormat switch (instead of the MergeFormat switch) and IF fields you can do it. You need the IF field to test for your condition and then have the results of the IF field be merge fields themselves, formatted the way you want.  SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. >I have an excel 2003 spreedsheet that I am using as a database in a Word >2003 [quoted text clipped - 4 lines] > something similiar in the word table that stores the mail merge fields? It > brings the R into the word table but not the color. Thanks for the help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.