Returning rows that have a highlighted cell

[benrrich]

I am comparing a spreadsheet vs database information. I am given a spreadsheet of addresses and I have compared the zip codes by Conditional Formatting, highlighting the duplicate values. Is there a way to only show all the data on the row of the selected area where the zip code is highlighted?

 

[Yongle]

allow data to be filtered
click on Data tab \ select any cell in your data \click Filter
then
click on dropdown for zipcode \ filter by color \ select the color