I have an Excel model that after I moved it from 2003 to 2007 has a lot of
redundant conditional formatting rules. Some conditional formats moved fine,
other cells have the same rule duplicated 10 to 12 times.

Is there an easy macro way to remove duplicate conditional formatting rules?

Also, my conditional formatting rules usually should be the same if they are
on the same row looking up/down the existing column to see if conditional
formats conditions are triggered. Even though I setup the rule correctly
locking the row or column as needed, it looks like Excel considers it to be a
different rule for each column. I think this is slowing down my model.

Thanks,
Ken