Free · No upload · No account
Compare two Excel sheets and highlight the differences
See added, removed, and changed cells in color, the moment you drop two files. No helper sheet, no conditional-formatting formula to babysit — and no false red across rows that only shifted.
Highlight your differences right here
Drop two sheets or two files. Added cells turn green, removed cells red, changed cells amber — all in your browser.
Old / Base file
.xlsx .xlsm .xls .xlsb
or click to browse
New / Modified file
.xlsx .xlsm .xls .xlsb
or click to browse
What the colors tell you
Every cell is sorted into one of three buckets, so you can scan a sheet and know what happened without reading a single number.
A cell or row that exists in the new sheet but not the old one.
A cell or row that was in the old sheet and is gone from the new one.
A cell that exists on both sides but whose value or formula is different. Old and new shown together.
So a single inserted row reads as a band of green, a deleted column as red, and a corrected discount rate as one amber cell showing 8% → 9%. No legend to memorize.
The manual way, and where it falls down
You can highlight differences in Excel by hand with a helper formula and conditional formatting. It’s worth knowing, and for two small, identical-shape sheets it’s fine. The formula at the heart of it is a cell-by-cell inequality test:
=Sheet1!A1<>Sheet2!A1- 1
Put both sheets in one workbook, lined up so A1 means the same cell on each.
- 2
On a third “diff” sheet, in A1, enter a cell-by-cell test that returns TRUE where they differ.
- 3
Fill that formula across the whole used range so every cell has its own TRUE/FALSE.
- 4
Add conditional formatting: shade any cell where the test is TRUE.
- 5
Read the shaded cells — those are your differences, as long as nothing shifted.
Why it stops working on real workbooks
It breaks on inserted rows
The formula compares A14 to A14. Insert one row on a side and every row below it tests as different, painting the whole sheet red over a single edit.
It can’t tell value from formula
Two cells can show the same number while one is typed and one is a formula. A plain <> test calls them equal and you never see that the logic changed.
It only flags, never explains
A shaded cell tells you something differs, not what it was or what it became. You still open both files to read the old and new value.
It’s fragile to maintain
The helper sheet, the fill range, and the formatting rules all have to be rebuilt whenever the data grows or the layout shifts.
SheetDelta does the same highlighting without the helper sheet — and because it aligns rows first and reads formulas, the cases that break the manual method are the ones it handles best.
Frequently asked questions
How do I highlight differences with conditional formatting?
=Sheet1!A1<>Sheet2!A1 filled across the used range, then apply a conditional-formatting rule that shades cells where the formula is TRUE. It works for tidy, same-shape sheets — but it breaks as soon as a row is inserted, and it can’t tell a changed value from a changed formula. SheetDelta does the same highlighting in one drag and handles those cases. What do the colors mean?
Does it highlight formula changes, not just values?
Can I highlight differences between two files, or only two sheets?
Will inserted or deleted rows ruin the highlighting?
Is it free, and do my files get uploaded?
Highlighting the same sheets again and again?
Let SheetDelta watch your SharePoint or OneDrive files and surface the highlighted changes for you, with review comments and an audit trail — instead of rebuilding the helper sheet each time.