Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2019, 07:53 AM
Sophocles Sophocles is offline Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge Windows 10 Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge Office 2016
Novice
Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge
 
Join Date: Feb 2019
Posts: 1
Sophocles is on a distinguished road
Default 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
Attached Files
File Type: docx Mail Merge Document.docx (12.6 KB, 10 views)
File Type: xlsm TESTING.xlsm (22.9 KB, 9 views)
Reply With Quote
  #2  
Old 02-06-2019, 01:15 PM
macropod's Avatar
macropod macropod is offline Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge Windows 7 64bit Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge 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
Carrying Conditional Formatting (Cell Colours) From Excel into Word during Merge Conditional formatting of cell, Excel 2003 Scaffold Excel 2 05-01-2010 08:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft