Hi all

I was wondering if I could get some help on this, to be honest I don't even know if it's possible!

I currently have a word document which I populate from excel using VBA coding and bookmarks within the word document, I transfer text and number values into a table in word. What I want to do is based on a cell value in excel, I want fill a cell on word with a colour. For example if the text within the excel worksheet states red, then in the cell on the table in word will fill with red. I hope that makes sense. Below is an example of code I use to transfer text and number values to word.

Thanks in advance for any potential help.

Please Login or Register  to view this content.