Remove conditional formatting, keep formats.

Hello.

I have seen this question posted on many forums in the past but never seen a solution that works. I should say that I use Excel 2011 on a Mac.

So basically what I want to do is to clear a sheet from conditional formatting but keep the formats. This would imply "freezing" the formats and then removing the rules.The result would be a worksheet that looks identical to the one before, but without conditional formatting applied.

Does anyone know how to do this?

Bumping myself here... Does anyone know? I have tried just about every macro that is out there but nothing works.