Unanswered: Mailmerge from conditionally formatted Excel 2010
This may not strictly be an Excel question as the problem occurs in Word 2010 when I am merging from an excel sheet.
Basically I have conditionally formatted my excel sheet to show a seperate text value for a list of fifteen numerical values that get entered. Obviously when I merge this cell in to my Word Document, the value displayed is the "real" value of the cell (ie the number) rather than the displayed text. Is there any way of getting the word document to show the text instead?
I had a look at IF...THEN rules (in Word) but couldn't work out how to do a list of rules rather than just one. I found some tutorials online about multiple input values but they were only based on getting a true/false output. I don't want that - for each of my 15 inputs I have a seperate output value.