Model Validation/Audit Tools and Techniques - How to find inconsistent formulas in a financial model

One of the most common reasons for spreadsheet errors is inconsistent Excel formulas. You look at the first few cells and the formula looks exactly the same so you assume that the whole row is correct, but hidden somewhere is an inconsistent formula that will cause chaos. The idea of consistency is one of the good spreadsheet practices to be encouraged/ enforced.