Formatting Issues

How to Highlight Changed Cells in Excel Without Legacy Tracking

Ayan Masood Oct 10, 2026 868 views

Question details

The user wants to highlight cells that have been modified in Excel without relying on the older legacy Track Changes feature.

How to Highlight Changed Cells in Excel Without Legacy Change Tracking

Product: Microsoft Excel
Device & OS: not provided
Scenario: Tracking edits and highlighting modified data in a worksheet visually.
Observed behavior: Excel cannot automatically compare a cell with its historical value natively without using Show Changes or setting up a manual conditional formatting comparison with original data.

Before you start

Ensure you have a backup or a copy of your original data before making edits, as you will need an untouched version of the sheet to set up a conditional formatting comparison.

Solution 1Recommended

Use Conditional Formatting to Compare Worksheets

Duplicate your original data to a new sheet and use a conditional formatting formula to automatically highlight any differences in your current sheet.

Since modern Excel no longer supports legacy change tracking for offline files by default, comparing your active sheet against a hidden original copy is the most reliable way to highlight edits.

Duplicate the Original Sheet

Before making any edits, right-click your worksheet tab at the bottom, select 'Move or Copy', check the 'Create a copy' box, and rename this new tab to 'OriginalData'.

Select the Current Data

Go to your active worksheet where you will be making changes and select the entire data range you want to track (for example, A1:Z100).

Apply Conditional Formatting

Navigate to the Home tab on the ribbon, click on 'Conditional Formatting' in the Styles group, and select 'New Rule'.

Enter the Comparison Formula

Choose 'Use a formula to determine which cells to format'. Enter a formula like `=A1<>OriginalData!A1` (ensure A1 matches the top-left cell of your selection).

Choose a Highlight Format

Click the 'Format' button, navigate to the Fill tab, pick a highlight color (such as yellow), and click 'OK' twice to apply the rule. Any changed cell will now be highlighted.

Use Conditional Formatting to Compare Worksheets

Dynamic Highlighting: This method is fully dynamic. Whenever you change a cell's value so it no longer matches the 'OriginalData' sheet, it will instantly light up with your chosen color.

Solution 2

Review Edits with the Show Changes Feature

Use Excel's modern Show Changes pane to view historical edits if your file is saved and synced on OneDrive or SharePoint.

Efficient Data Management

Track and Highlight Changes Easily with WPS Spreadsheet

WPS Office provides a highly compatible, free, and lightweight alternative for managing complex spreadsheets. You can easily duplicate sheets and apply conditional formatting to track modifications precisely as you would in Microsoft Excel.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your workbook.
2. Copy your original data: Right-click the sheet tab and select 'Move or Copy' to keep an unchanged version of your original data.
3. Apply Conditional Formatting: Select your active data range, then go to Home > Conditional Formatting > New Rule.
4. Input the formula: Select 'Use a formula', enter your comparison formula (e.g., `=A1<>Original!A1`), and set a custom highlight color to track your changes.

Free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsFamiliar user interface with no steep learning curveRobust conditional formatting and data review tools

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see the Track Changes (Legacy) option in Excel?

Microsoft has deprecated the legacy Track Changes feature in newer versions of Excel. It has been replaced with the modern 'Show Changes' feature, which is designed exclusively for workbooks saved in OneDrive or SharePoint.

Does conditional formatting update automatically when I change a cell?

Yes, once you set up the conditional formatting rule comparing the two sheets, any new edits that differ from the original reference sheet will instantly trigger the highlight color without needing to refresh the page.

Can I track changes without saving my file to the cloud?

If you are working offline or saving locally, you cannot use the modern 'Show Changes' feature. You must use the conditional formatting comparison method or rely on third-party comparison tools to track your edits visually.

Document & File Issues