Mail Merge - Conditional formatting of table cells

[Maryetta]

Re: Conditionally Shade Table Cells in the Mailmerge Tips and Tricks thread at: http://www.msofficeforums.com/mail-m...ps-tricks.html
For now I have a database with two fields - Name and Score. The below images are where I am up to with the outcome and code and the way I would like it to be. I need the whole cell filled and preferably not to have the word High in there. Where I am confused is on the mailmerge tips and tricks website it says to create a "Set of fields for each condition".

[macropod]

There are no images attached to your post - which I've split from the thread you posted in to a new thread of your own.

The reference to "Set of fields for each condition" concerns the number of conditions you want to test. The example in the link demonstrates the testing of four conditions.

Whether you have any text as part of the output is at your discretion - the "Condition # Text" text is optional.