In Excel 2010, columns C and D in a sheet have conditional formatting on them to find duplicates. When users paste from other excel cells, it copies over both the value and the format, so the conditional formatting is destroyed.

What is the easiest way to preserve the duplicate-finding formatting even if users paste from other excel cells? I know users can "Paste Values," but often they forget. Is there an automatic way to preserve the formatting? Thanks.