Highlighting discrepancy after mail merge

[cmgtlg]

I have a Word document that I'm merging with an Excel file. Once the merge is performed, there is a column that shows a score (say 50/50). If the first number is not equal to the second number (after the slash), we'd like that to be highlighted in some way (either font color or highlight that should show in a black and white document), indicating a lower score.



Here is the current formatting for this column:

«tests_wcorrect_results_for_merge»/«tests_performed_and_evaluable_for_merge»

Please advise 1) if this is possible and 2) how to revise the above formula.

Thank you.

[macropod]

You will need a formula for that. Replace your existing «tests_wcorrect_results_for_merge» field with field coded as:
{=«tests_wcorrect_results_for_merge»-«tests_performed_and_evaluable_for_merge» \# "'«tests_wcorrect_results_for_merge»';'«tests_wcorrect_results_for_merge»'"}
where the second instance of «tests_wcorrect_results_for_merge» is coloured however you'd like it to appear when less than the «tests_performed_and_evaluable_for_merge» value.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces, single quotes and double quotes represented in the field construction are all required.