Not possible, you need to copy and paste the formats

--
Regards,

Peo Sjoblom



"Jamie" wrote in message
...
I am pulling data from one worksheet to another in the same workbook and
need
to keep the font color the same color in both cells. How can I do that?