Conditional Formatting is a mess.
Conditional formatting is extraordinarily useful in many ways, But MS hasn't dealt with the nightmarish tangle its use can create when rows, columns, and cells get moved around. In addition, conditional formatting is the only place in Excel where the mere movement of the cursor inserts a cell reference; I have never found a use for that, and while removing the extraneous reference I wonder what they were thinking. It is really just a mess. I was fully accepting of this situation in 2007, but I see no indication in 2010 that they are even aware of the mess that the current setup can create. It seems simple to build in a validation check that would spot the interrupted ranges and orphaned conditions that make conditional formatting almost beyond maintaining in a spreadsheet that gets modified a lot. Of course, each time one conditional format is split into two, the recalculation delay increases. This needs a LOT of work if it is not to be limited to Excel jocks with lots of time to straighten out zillions of screwed up conditional formulae and the ranges they apply to.
Keep Up with TechRepublic