excel

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

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?

Solution

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

    It worked perfectly for me.