title: Excel - Copy Conditional Formatting, Remove Rules, Keep Format
body: <p>I know you usually show what you've tried in a question, but this is more of a "Do you have a good routine that does this?" question and I'm hoping you'll be willing to let it slide...</p>
  
  <p>I'm working on a macro that copies cells that are conditionally formatted in a source worksheet and pastes them into an output sheet.
  Basically, I'm looking to keep all the formatting, shading, etc, but remove all the conditions (make the current formatting static) in the output sheet.</p>
  
  <p>I've seen some solutions online - ranging from copying it first to a word document and then pasting it back, to looping through the output cells and copying format-element by format-element - and am just looking for a good, efficient way to do this.</p>
  
  <p>Does anyone have one / a good link they'd be willing to share??</p>
  
  <p>(Excel 2010)</p>
  
  <p>THANKS!!!!</p>