http://tjshome.com/blog/249/guide/excel/accounting
I find very common when using conditional formatting and copy/pasting from one sheet to another that this link gets created with a reference to the original file. Break links doesn't really break them. Find them by clicking on
Home ribbon, Conditional Formatting, Manage Rules
change the "Show formatting rules for:" drop down to "This worksheet" and look for anything referencing a file instead of a rule, like in this case:
Change the formatting and you are set.
