Retaining conditional formats?

[shumba]

Hi,

I am using Excel 2007. After applying conditional formatting to cells A1 to A200 and then deleting some of those rows the conditional formatting is also deleted. The rows are deleted because they are duplicated items in the list. I have been doing this using the Remove Duplicates tool under the Data Tab in the Ribbon.

Is there any way to retain the conditional formats.

Any help will be much appreciated.

Thanks,

Rob.