Colour table cells in Microsoft Word after mail merge
Posted
by
James
on Super User
See other posts from Super User
or by James
Published on 2012-11-24T10:58:22Z
Indexed on
2012/11/24
11:13 UTC
Read the original article
Hit count: 291
I have an Excel spreadsheet of student data. For each of 30 topics, students are traffic lighted R, A or G (for red, amber, green) in the spreadsheet. I am mail merging individual result print-outs in Word 2010. However, rather than printing the letter R/A/G next to each topic, I would rather change the background colour of the cell to that colour.
How can I do this? Is there an option with merge fields or can it be done with a macro (please provide sample code if so - I don't have experience with macros!)
© Super User or respective owner