Conditional Formatting Duplication

[J00m82]

Hello,

When I cut/copy information from a weekly report into the new excel file that contains conditional formatting I am often left either having to paint-fill individual cells or redo the conditional formats altogether. I've noticed some duplications in the conditional formatting. Any suggestions?

Thanks

 

[Luke M]

When you paste, don't do a regular paste which trasnfers the value and format. Instead, just do a paste value. You can learn to do this quickly by either adding the Paste Values button to the QAT (Quick access toolbar), or using keyboard shortcut of Alt+E, s, v.

 

[J00m82]

Thanks for your reply Luke M. I do usually paste values, unfortunately I am still left with cells that are empty and unresponsive to format painter.

 

[Luke M]

I'm not sure what you mean. If you start with the worksheet properly setup with CF, and then paste value, you're saying that the format gets erased somehow?

 

[J00m82]

The CF is setup properly but some cells are left unaffected. Do you have ideas/suggestions what could be going wrong?

 

[Luke M]

I would have to see the actual worksheet and what rules are in place.