Is it possible to use conditional formatting in Microsoft Word 2007 Mail merge? I would like it to color the font, depending on the field value, for instance:
- if
"Priority"
field equals1
, color the font to red - if
"Priority"
field equals2
, color the font to yellow - if
"Priority"
field equals3
, color the font to green
I've tried using the "Rules"
-> "If... Then... Else"
and this could probably work, but creating rules using it is a nightmare…. Is there a better way?
Best Answer
Using If..Then..Else is the right start as it inserts an IF field into the document which is what you need, however the dialog which comes up isn't powerful enough to do this kind of thing so you will need to edit the IF fields manually in the document.
What you will need to have is IF fields which compare the value of the field and will display the field with desired color for the appropriate value. Don't forget the MERGEFORMAT switch so that this color is passed on to the merged text.