Preserve Cell Format

[maacmaac]

I am trying to find a way to preserve cell formatting. For example, cell A1 the color is Blue and the font size is 8. In cell B1 the color is red and font size is 10.

If the user copies cell B1 and pastes into A1, the format in A1 has been changed. I want to preserve the original formatting.

I tried to use conditional formatting, but that didn't work. Is there another way to accomplish this?

Thank you in advance for any comments. If this can't be done, please let me know.

[VBA Noob]

You could use code. The below activates when the user copies and then paste special values if they use Ctrl + v to paste.

Right click the sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

then in a normal module place this code

Please Login or Register  to view this content.

HTH

VBA Noob

[maacmaac]

That works fine except that the code doesn't "reset" itself after the intial copy and paste. i.e. if I copy and paste a second time (say from another cell or another spreadsheet), the original formatting is no longer preserved.

I hope that makes sense.

Thanks