01-17-2014, 12:18 AM
|
Expert
|
|
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
|
|
Revised now I understand the colouring is at character level, not cell level … - 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
What I did …- selected the single column in Excel
- pasted it into Word – this gives a table
- converted the table into text (Table tools, Layout, Convert to text)
- selected all the text, applied a heading style with Page break before and text colour Automatic
What you could do to finish the conversion is …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>
HTH!
|