Conditional Formatting - how to minimize formatting rule duplication with editing

Hi Nabil,

Attached is a slimmed down version of my spreadsheet showing my issue with inserting rows after the sheet is protected. The sheet is protected with no password. The formula I'd like to carry on is in Column R. After I follow the instructions listed above, protect the sheet, and insert a row, the formula cell in Column R doesn't copy. I've tried copying the formula formatting into the inserted row, but it doesn't work because the cells in Column R are locked for editing. This is the debacle I am currently facing. :)