how can I keep the cell format the same (protected) when I copy and paste
another cell into it?
ie.
Cell A1 from Sheet 1 is protected with center justified-text along with cell
color RED. This sheet is protected and user is not allowed to edit the
format.
Cell B1 from Sheet 2 is left justifed with no cell color.

If I copy B1 Sheet2, and paste it into A1 Sheet1 (Format protected), the
red cell is now not colored RED, and the text is now Left-Justified.
How do I keep the cell red and centered justified. I mean....shouldn't it
keep it's format since it's protected from changing?