- was cross posted to excel.templates..

Folks,

I am busy working on a rather complex spreadsheet that allocates operations
costs and salaries to feed multi-year Income Statements, balance sheets and
cash flow statements. In all the sheets have several hundred of formulas
that can go wrong. copied incorrectly, logic errors, etc) With all the
allocations and consolidation it has become neccessary to put in significant
error checking..

Error checking used so far:

(1) Conditional Formating - Display the word "Error" when two cells that
should match don't. This is acheived by using a white font colour when the
cells match and red when they don't.

(2) If Statements - Display the cell value when the logic test fails.

(3) Display the delta between two cells that should match - rounding where
required.

(4) A verification sheet to summarize the key tests using a combination of
the above.

It still takes too long to track down the offending formula or logic error.

Being rather certain that others have solved these problems long before I
knew they existed I am looking for advice and tips.

Thanks in advance.

Peter