Highlight different cells in two lists in #Excel

Finding and highlighting differences should be a common task in Excel. Most of the time, it’s solved by formula or conditional formatting. Either way, we need to construct a simple formula like the one below to compare the cell contents in two lists.

= A1 = B1 

In this post, I am going to show you a non-formula approach which is very handy, especially when we are dealing with a one-off task. What we need is just a few keystrokes, or mouse clicks.

Let’s watch it in action:

Prefer reading to watching? No problem. You may refer to the blogpost HERE or continue to read.

In short, the trick is using Go To:

  1. Select the two lists
  2. Ctrl+G to open Go To dialogue box
  3. Alt+S to select “Special”
  4. W to select “Row difference”
  5. OK

There we go. All cells that are different from the corresponding position in the other list will be selected. We can format those cells to highlight them. Or simply press Ctrl+B to make them BOLD.

Isn’t it magical? 😁

Wishing you a Merry Christmas and a Happy New Year! πŸŽ‰

I appreciate all your support in the past! And looking forward to sharing more Excel magic in the future.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.