Copy a worksheet with Conditional Formatting to a new worksheet without duplicating

Hi

I am trying to copy a worksheet with conditional formatting to another worksheet. Everytime I have done this it is duplicating some of the conditional formatting, how do I stop this?

Hi jklfinlay

How about paste value's!

That didn't work.

I need the worksheet that contains the conditional formatting to retain all conditional formatting that is currently in it nad when I copy it to a new worksheet I would like the conditional formatting to remain but jsut not duplicate. At the moment I am right clicking on the Worksheet TAB I would like to copy I select Move or Copy, then select copy - I thought in doing this the conditional formatting will be copied across to the new worksheet, but for some reason it is copying it across but duplicating some of the the formating as well but not all of it.