#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
No need to spend time in writing formulas /code
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.