paste conditional formats as formats

[Guest]

When having done an extensive conditional formatting I managed to get my
cells colored the way I want.
However, the conditional formula is still active. Changing data will change
the format. How can I fix the formatting result of the FIRST conditonal
formatting so that changing data afterwards does not alter the foramt again.
I have tried pasting special, but could not find the "undo" conditionals.

 

[Guest]

If you want to remove conditional formatting, select CF and then Delete
button. You can then delete any or all of the conditions.

Is this what you want to do?

 

[Guest]

NO, not exactly.
The conditional formatting result is what I want to keep.
Deleting the CF will remove the coloring too.

(reason I want the cf removed is the time it takes and slows down the
workbook activity.)
I have 1200 lines and 45 rows that for each cell check approx. 100.000
records to base the cf on.
Once that is done I want the color to remain as CF defined, But need to do
further steps in processing the data.