How to remove Applied Conditional Formatting in a Copied Sheet(s) retaining Format?

How to remove Applied Conditional Formatting in a Copied Sheet(s) retaining Format?

Dear Forum,

I am creating several CopY sheets from a Parent WorkSheet and these Copied SHeets are without any Formulas but only have values and exactly the same formatting as the Parent WorKsheet...

I have managed to get the Copied Sheet with Values and the Formats but how do I remove the conditional formatting so that there are not formulas in the conditional formatting box as well as retain the formatting which was happening due to the Condtional Formatting..

I know it sounds contradictory however never know what all is possible?

If its possible then what code I need to add during the Copying Operation and also exactly where do I add it to not disturb the Conditional FOrmatting of the Parent WorkSheet.

Warm Regards
e4excel

Dear TMShucks,

I even share the same feeling it mighr not be possible but who knows there might be some kind of VBA code to achieve that..!

The way we copy a cells Value excluding the formula retaining the same contents, I wnat to remove the conditional formatting formulas in the bars but at the same time retaining the Formatting..

I am working on Excell 2007 and creating replica of the Sheets which I want to save as Excel 2003 and I am only having three conditions in CF..

So any suggestions please feel free to add..

Warm Regards
e4excel

Any takes on that!