Use paste special - bitmap to retain font and cell colors.

"JB in Kansas" wrote:

When I copy an Excell spreadsheet and paste it into a Word documet as a
Metafile, I loose the font color. The logos and filled cells paste in color
only the text does not.