View Single Post
 
Old 01-17-2014, 12:18 AM
eNGiNe eNGiNe is offline Windows 7 32bit Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

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 …
  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
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!
Reply With Quote