Locking conditional formatting

Hi,

I have created a shared document for monitoring report data coming by e-mail.

The set up is as follows;
Sheet1 - Contains the updated data that we use to support the daily activities

Sheet2 - Contain the raw data from the report. At every update the e-mail report in copied to this sheet and automatically tells me what data is new and what data has been changed from the previous update. The new and updated data is then manually copied over to Sheet1 (with a few additional parameters added manually).

I have done this with a formula that returns a TRUE/FALSE statment depending if data is new or already existing.
I have then added 2 conditional formatting rules to clearly indicate new data, and changes in existing data.
New data is recognised in red, and changes in existing data recognised in yellow.

This works well also for team members with only basic Excel knowledge.

The problems comes into the picture whenever someone copy+paste the report data from the e-mail over to Sheet2. Each time this is done the conditional formatting rules are distoirted and needs to be corrected in order to highlight the data as intended.

Can I somehow lock the conditional formatting rules to specified cells and prevent unwanted changes when my team is working with the document?

Thanks in advance!