How to Highlight Values When They Change in Microsoft Excel

by C. Taylor, Demand Media

Highlighting Excel changes helps track important modifications.

Hemera Technologies/PhotoObjects.net/Getty Images

When multiple people work on the same Excel spreadsheet, it can be difficult to keep track of changes. As an example, a balance sheet might have been updated to reflect new payments. To draw attention to these changes, Excel offers a "Highlight Changes" feature that draws a border around changed cells and places a triangular tab within the cell. Even if you are the only one working on the spreadsheet, this feature is helpful for identifying recent changes you made in the current session.

Step 1

Open your spreadsheet in Microsoft Excel.

Step 2

Click the "Review" tab. Click "Track Changes" from the Changes group and select "Highlight Changes."

About the Author

C. Taylor embarked on a professional writing career in 2009 and frequently writes about technology, science, business, finance, martial arts and the great outdoors. He writes for both online and offline publications, including the Journal of Asian Martial Arts, Samsung, Radio Shack, Motley Fool, Chron, Synonym and more. He received a Master of Science degree in wildlife biology from Clemson University and a Bachelor of Arts in biological sciences at College of Charleston. He also holds minors in statistics, physics and visual arts.

Photo Credits

Have Feedback?

Thank you for providing feedback to our Editorial staff on this article. Please fill in the following information so we can alert the Small Business editorial team about a factual or typographical error in this story. All Fields are required.