View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leo leo is offline
external usenet poster
 
Posts: 74
Default 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.