Excel - How To Compare Two Sheets In Excel For Differences - Episode 1266
Microsoft Excel Tutorial: Comparing Two Worksheets.
Welcome back to another episode of the MrExcel netcast! In today's episode, we will be discussing a question sent in by Ray about comparing worksheets in Excel. This solution is specifically for Excel 2010, as it was supposed to be included in Excel 2007 but was not in the final product. But don't worry, we have a workaround for those using Excel 2007 or earlier versions.
Ray has two worksheets with similar data, one for January and one for February. He wants to highlight any cells in the February worksheet that have changed from the January worksheet. To do this, we will use conditional formatting. First, select all the cells in the February worksheet. Then, go to the Home tab and click on Conditional Formatting. From there, select New Rule and then choose "Use a formula to determine which cells to format."
Now, we need to write a formula that will compare the cells in February to the cells in January. In this case, we will use the formula "B3＜＞Jan!B3" which means if the cell in February is not equal to the cell in January, it will be highlighted. You can choose any formatting you want for the highlighted cells, such as a green fill. This feature of conditional formatting, where you can refer to cells in another worksheet, is only available in Excel 2010 and newer versions.
I hope this solution helps those of you using Excel 2010 or newer. And for those using older versions, it may be time to consider upgrading to take advantage of this great feature. Thank you for watching this episode of the MrExcel netcast. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(00:00) Comparing Excel Worksheets
(00:30) Using Conditional Formatting
(01:20) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
how to compare sheets in excel
how to compare two sheets in excel
how to compare two sheets in excel for differences
how to compare two excel sheets for changes
how to compare two lists in excel spreadsheets
how to compare two excel spreadsheets youtube
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Ray asks how to use Conditional Formatting to compare two worksheets. This feature is "new" in Excel 2010 - compare two sheets using Conditional Formatting. Today, in Episode #1266, Bill shows you how to work with this new feature. Learn Excel!