Here is a copy of the file attached to post #1, perhaps looking at the setup of the named range and conditional formatting will be helpful. If the applies to doesn't change when you insert and/or delete rows then I suppose that it could be a difference between versions.
Bookmarks