See attached spreadsheet.

I made it a table and added a Reconciliation column to show where the daily total doesn't equal zero. Then the conditional formats applied to each column show the problem days in orange and problem transactions in red.

Attached Files

Sample Data.xlsx (21.4 KB, 7 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia