I am building reports by pulling Excel data into a mail merge document. I would like to have the text color of some of the fields be determined by the value of that field. Here is what I have come up with that is "kind of" working:

{ if {MERGEDFIELD Revenue} < {MERGEFIELD Revenue_Goal} {MERGEFIELD Revenue\*charformat} {if { MERGEFIELD Revenue} > {MERGEFIELD Revenue_Goal} {MERGEFIELD Revenue\*charformat}}}

Now, this works most of the time, but there are occasions where I am previewing and Revenue < Revenue_Goal and the font stays green. If it makes any difference, I am connecting via MS Excel via DDE and it is keep currency formatting in the mail merge.

Thanks in advance!