Conditional formatting changing even though protected.

Question

I created an excel spreadsheet for my teams with conditional formatting in nearly all the cells an employee will fill out. This is the second version. The first version has been in use for a while. I had to make what drives the conditional formatting variable on this second version—as different teams needs to be able to set their own % goals based on their business unit. The hope was that I could lock the spreadsheet to protect the formatting, and they could copy/paste from the old sheet and not have to completely re-enter the data. The result is... even though the new sheet is protected, the old conditional formatting is carrying over from the old sheet. How can I protect the conditional formatting so it is not overwritten?

Answer 1

Dear Geno E. Allen,

Greetings! Thanks for posting in Microsoft Community.

I understand that you have an issue on conditional formatting. Before moving forward, we need more detailed information about the situation you are experiencing.

Kindly share with us the information below:

1.Your Office version, you could check it through Files>Account.

2.If you could attach screenshot of the sheet or share us sample files with different formatting you want to use will be great help. So we could understand your requirement better and test on our device to give a proper solution. You could share the files with OneDrive share link.

We look forward to your response. Thanks for your cooperation.

Sincerely,

Sean | Microsoft Community Moderator