Excel Intermediate: 

#2:Compare two lists instantly

Solution: 

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 

Benefits:

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.