You can easily create tests for cases like that in excel. For example, if you know that all cells in a column must conform to specific conditions, you can creat

You can easily create tests for cases like that in excel. For example, if you know that all cells in a column must conform to specific conditions, you can create a new cell with a formula that validates the other cells. I have a bookkeeping excel where the "validation cell" becomes red when it detects errors.