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: No need to spend time in writing formulas /code Instant way Alternatively you can watch my below video …