I have a macro that compares to columns and highlights in Color Index 6 any duplicates (I don't want to delete them).

I do however want to sort the listing to isolate those cells that are Color Index 6. If anyone has any ideas how this is possible I'd greatly appreciate it.

Thanks

Darren