Mail Merge - Conditional formatting of cell background color

[macropod]

I just need the CELL CONDITIONALLY FORMATTED to the correct colour based on the score. 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.

You don't need to have any conditional text, just the required formatting. Note that you need to apply highlighting to the I of IF, not a font colour.

Where I am confused is on the mailmerge tips and tricks website it says to create a "Set of fields for each condition". I dont understand why?

Because you have 3 conditions and to need an IF test for each. That doesn't imply having a Condition1 field, a Condition2 field, and a Condition3 field; the same field can be tested for all 3 conditions. Hence:

{IF{MERGEFIELD Condition}= "HIGH" "→→↵
→→↵
→→" \* Charformat}{IF{MERGEFIELD Condition}= "MID" "→→↵
→→↵
→→" \* Charformat}{IF{MERGEFIELD Condition}= "LOW" "→→↵
→→↵
→→" \* Charformat}