View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cv cv is offline
external usenet poster
 
Posts: 8
Default Find/Filter highlighted cells

I have used conditional formatting to find duplicates in a spreadsheet, they
are now highlighted with yellow colour. How can I easily filter / find the
highlighted cells in a large spreadsheet and avoid scrolling thousands of
lines?