Keeping conditional formatting colours from excel into word mail merge

Question

Hi all,I am trying to perform a mail merge into word using data from excel. The data is exam target grades and review grades which are colour coded according to progress made (red, amber, green and so on). Is there a code I can use to make the colour coding appear in the word document? The problem is that the colours correspond to each individual's progress so I can't just use a simple code to make all A grades green for example:Pupil     Target      Actual1               A               A* (conditional formatting recognises this is one above the target and so turns blue)

2               A*             B (conditional formatting recognises this is two below the target and so turns red)

3               B               C (conditional formatting recognises this is one below the target and so turns amber)

4                C              C (conditional formatting recognises this is on the target and so turns green)I think I need to copy the colours from excel rather than entering a condition in word - not sure if that makes sense so thank you so much in advance for your help!Kind regards,Jo

---

Answer 1

It is not possible to retain Excel's conditional formats when doing a mailmerge. However, you can apply the same logic that created the conditional formatting to the Word mailmerge main document itself. See Conditionally Format Mailmerge Output and Conditionally Shade Table Cellsin the Mailmerge Tips and Tricks thread at:

http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html