• content: single-column Excel, some words in each cell coloured – Be kind, because everyone you meet is facing some kind of a battle
• goal: multi-page Word, each cell on separate page, colour preserved

1. selected the single column in Excel
2. pasted it into Word – this gives a table
3. converted the table into text (Table tools, Layout, Convert to text)
4. selected all the text, applied a heading style with Page break before and text colour Automatic

set up character styles and use those to apply your special colouring: this will make it easier to find/retrieve coloured words, and to add new records by hand if you need to

In general, style-driven changes are preferable to local overrides <g>