paste conditional formats as formats
 

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.

paste conditional formats as formats
 

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?



"leo" wrote:

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.

paste conditional formats as formats
 

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.

"Toppers" wrote:

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?



"leo" wrote:

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.