| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find/Filter highlighted cells
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: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to find out the color an excel cell is highlighted? | Excel Worksheet Functions | |||
| how to filter out highlighted cells | Excel Discussion (Misc queries) | |||
| Find Highlighted Cells | Excel Discussion (Misc queries) | |||
| Can I filter a row depending on the colour that I've highlighted it with? | Excel Discussion (Misc queries) | |||
| when using find I want the box in excel to be highlighted | Excel Worksheet Functions | |||
Hybrid Mode
