excel - How to copy the conditional formatting without copying the rules from a Conditional Formatted cell?

Question

I have a row of data with conditional formatting in it.

I need to copy this row to another row. This new row must be identical (values, formats), but static, i.e. without the rules. If I copy and paste the row and clear the rules, the formatting from the CF rule vanishes.

Is it possible?

Answer 1

Just discovered an easy way: Copy the table to MS Word and copy it back to excel :D

---

It worked perfectly for me.