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.

Answer 2

Copy and paste to Google Sheets, then copy and paste back into Excel.

(I had to resort to this because the copy/paste to Word didn't work for me)

Answer 3

I found a dead easy solution to this problem.

1. Copy the cells with the results of conditional formatting that you want to duplicate in another place.

2. Paste into an OpenOffice Calc spreadsheet (I used build 4.1.5) as Formatted - RTF. The formatting is still there, but OpenOffice apparently discards the conditions that created the formatting in the first place.

3. Now simply copy and paste into Excel.

4. Crack open the champagne.

This works with Excel files thousands of lines long.