Highlighting discrepancy after mail merge
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.
|