Highlight values based on a range of values. Excel
<p>In excel, in a range of cells (say A1 to A100) highlight only values that contain any of  the values in a specified range (say A101 to 150). Duplicates among A1 to A100 SHOULD NOT be highlighted. Anybody has a solution?</p>