#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. 



Leave a Reply

Your email address will not be published.