I recently posted a question about making a font Red and Bold by the use if conditional formating in a mail merge. I did receive a useful reply from one user of this forum pointing out the issue was spaces. It was also suggested I could use an alternative syntax.



The original syntax with correct spaces is:

{IF {MAILMERGE HR}>80 {MAILMERGE HR} { MAILMERGE HR}}

Once I sorted out the correct spaces, this worked. However, using the exact syntax with the correct spaces it does not work for any other field. For example:

{IF {MAILMERGE QRS} >15 {MAILMERGE QRS} {MAILMERGE QRS}}

It was also suggested I could use the following syntax:

{={MERGEFIELD PR}>199 \#"'{MERGEFIELD PR}';'{MERGEFIELD PR}'"}

Using this syntax I do not get the error I was getting but I also do not get the bold if the value is greater than that quited.

Anybody have any ideas where I am going wrong? The mail merge is linked to an Excel file, Word 2010, Excel 2010, Windows 7 and Windows 8 PC used.

Thank you for any advice