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.

"bhodge" wrote:

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.
--
Charles 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.


"bhodge" wrote in message
...
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!