I have a word document I'm using as a mail merge connected to an Excel spreadsheet. In the word document are a set of tables, each cell populated by one or more fields from the Excel spreadsheet. There are three fields that are meant to turn red when the merge field = 'Red', green when it is 'Green', et cetera. The problem is, conditional formatting won't work in Word, so I have to figure out some way to format these cells without it.
I was hoping for some sort of solution that would utilize the word-merge's If-Then-Else rule, but I don't think that's possible. Any help is greatly appreciated.