The last thing I’ve been trying to do with this mailmerge is to do a conditional format in cells that contain certain words eg.

Good= Light green
Very good = dark green
Poor = yellow
Bad = orange
Very bad = red

Please would it be possible to show me how to do this.
Many thanks