|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge
Hi,
Firstly, please understand that I'm relatively inexperienced in both Word and Excel. I've managed to create a successful merge from an excel document, but need to carry over cell formatting to the word document itself. I have attached both documents. Where 1.1, 1.2, 1.3 etc refer to criteria on the word document I would like for the cell in the table to fill with the same colour. I have managed to get it copy the text written and format that, but it's not the same. I need the whole cell filling. Is there a way of making this work or am I going about this in the wrong way? Thanks, Sophocles |
#2
|
||||
|
||||
A mailmerge carries only the data, not formatting like fonts, colours, etc. To conditionally colour the table cells in your document, you'll need to take the approach described under Conditionally Shade Table Cells in the Mailmerge Tips and Tricks 'Sticky' thread at he top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
Question re: Conditional formatting (cell occurs after another cell) | Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Conditional formatting of cell, Excel 2003 | Scaffold | Excel | 2 | 05-01-2010 08:56 AM |