How do you change text color on facebook?

Color of text shd not change

• I have seqences which has some alphbets into red color. Now I run a macro and when those sequences are pasted to next sheet all text comes into black(default) color. Is there any way that the text color should not change even pasting or running the macro to different sheet. for eg. SPSPAGGGSSPYSR In the above text all 'S' is in red color in thesheet. How should I format the cells so that the color is not changed. Thanks and manu

• Answer:

  Manu, the only way to have some characters as red and others as black is to use rich text formatting - so you have done what you can. If you copy and paste the whole cell, then it should retain that formatting. If a macro is copying the data to another sheet, there is no guarantee that it is doing a copy and paste. It could be doing a value assignment. A value assignment doesn't maintain rich text formatting. If it is the macro I wrote, then I suspect it isn't doing a copy and paste.