Hi,

I want to protect a cell format where if I paste the data from other source format should not get change.

Ex: I am protecting A1 Cell format with Yellow color background, now I am copying the data from other source which contains Red color background and pasting in A1 Cell (which is format protected) now the target cell background get changed to Red.

I don't want to get change the format of the cell in any circumstances.

This problem is arising when I gave a standard template format to site officers, they are copy pasting the data from other files and it is effecting to template

Kindly advise on above