Find/Filter highlighted cells

  • Thread starter Thread starter cv
  • Start date Start date
C

cv

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?
 
I suggest to use a helper column with the same formula in it used in CF. Then
You can use Autofilter (for TRUE) to display the duplicated cells only.

Regards,
Stefi

„cv†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Typed text appears in wrong cell 0
Filter by Colour - conditional formating 8
How do I find cells with invalid data and true conditional formatt 1
Code to show if a cell has met conditional formatting 6
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Code to identify whether a cell has manual highlighting or not 5
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top