This project has moved and is read-only. For the latest updates, please go here.

Conditional Formatting question

Oct 27, 2014 at 6:34 PM
How do I only remove conditional formatting?
Or how do I copy a worksheet range without the conditional formatting?

I want to keep everything else, i.e., values, formats, etc.
Oct 27, 2014 at 7:01 PM
It wasn't supported until now. Pick up the latest source code. You'll be able to do

worksheet.ConditionalFormats.RemoveAll(); // Remove all conditional formats on the ws

worksheet.ConditionalFormats.Remove( cf => cf.Range.Contains("A1") ); // Specify a predicate to match which conditional formats to remove.
Oct 27, 2014 at 7:50 PM
Thanks. I built from source and used it. It works.