All, please excuse me if I have posted in the wrong forum. Am at my wits end.....

I want to do a mail merge into MS Word. The speadsheet I am using has many coloured cells (green) to indicate changes between earlier and upated info.

My questions -

(1) is there any way to perform a mail merge on the info contained only in the coloured cells?

or

(2) is there any way that merged info in the document will be formatted differently (italics, or coloured, or...) to indicate that the data has come from a coloured cell in Excel?

Many thanks, c.