pasting colored text doesn't paster via paste special

**daqddyo1** · 01-08-2015, 12:19 PM

I am using paste special to copy text in a group of cells into a set of cells on another page.
This happens except that colored text pastes as black and white text. What change(s) do I have to make to paste the text color as well?

Thanks

**newdoverman** · 01-08-2015, 12:31 PM

If you have under PASTE a choice to Keep Source Formatting, use that and the formatting will be pasted along with the values.

**daqddyo1** · 01-08-2015, 05:47 PM

Thanks,

That got it!

daqddyo1

**newdoverman** · 01-08-2015, 05:55 PM

Thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.