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