I've created a form in excel and every second row is got different colours to look nice. The cells with formulas are protected so the user can’t change them but in the cells where the data has to be entered by user is unprotected. Often what the user does is copy and paste and it messes up the colours of the rows. Is there any way to lookout the user to change formatting of the cell when he or she does copy and paste? Thanks in advance.