I had a huge problem last winter with Excel 2007's Conditional Formatting. I made rules, and I got huge problems a bit later - Excel decided to remove all formats from whole workbook!

Has anyone else had similar problems and more importantly, how di you get past it?

Conditional formatting is great in theory, but how to make sure it's not a Pandora's Box?