See attached.

I have a table with a Macro (see button " Insert new row" ref Macro "Copyrow") that protects the table and inserts a new row. This part works great. The issue I am having is getting the conditional format to highlight duplicates in all of column C. If I enter in duplicated numbers outside the table it the conditional format works. Even works when the sheet is unprotected IN the table. The second I hit the button to insert a row and enter a duplicated number the conditional formatting stops.


Any ideas on how to get this working?

Thank you so much!
Sample RPT.xlsm