I have a sheet on my workbook on which users frequently past data onto from other workbooks or text documents. The issue I have is unless the user right clicks and selects past special and chooses Values only then the formatting ** those cells gets all messed. How can I force pasted data to only paste values only, or alternatively lock the conditional formatting so pasted formatting gets ignored?