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
|