Feb 26

#2:Compare two lists instantly

Excel Intermediate: 

#2:Compare two lists instantly


1. Select  range in both lists 

2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK 

Play this trick immediately to do your quick comparison instantly 


  1. No need to spend time in writing formulas /code

  2. Instant way

Alternatively you can watch my below video for better clarity. 

if the video is not visible please click here.

Please leave your comments below if this tip is useful. 



About the author

Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">