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.
|