Conditional Format not working in a Protected Table

This is perfect TMS! Another feature that would be nice, is there a way to lock the data entered in the previous rows from being edited with having the current row able to edit. The user would lose the functionality to edit old row once the insert next row button is clicked.

Thanks again

Antexity

Thanks jaslake and skywriter for your observations, I have fixed those issues. Thanks!

Also to add to my latest post #6, is there a way to set a password when protecting and prevent from the end-user seeing the password. IE. I click the file and say protect sheet and use a password. Then I start adding rows and since in the macro, the logic is to unlock and lock the sheet, after the first attempt to unlock (and entering the password to unlock) and then lock I lose the password feature. If there is a way to address this and the solution is to hard code the password in the Macro logic, is there a way to prevent the end user from going to the developer tab > macro or view code to see the password?

Thanks
Antexity