View Single Post
 
Old 02-06-2019, 07:53 AM
Sophocles Sophocles is offline Windows 10 Office 2016
Novice
 
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, 13 views)
File Type: xlsm TESTING.xlsm (22.9 KB, 11 views)
Reply With Quote