deleting non highlighted cells after conditional formatting

[Wanda Almeida]

Hi, I used conditional formatting to highlight duplicates. I now want to remove the non-highlighted(unique) values. Easy to follow steps without having to use a macro would help. thanks.

[Pepe Le Mokko]

Hi
I suppose you can to the same as with XL 2010 where you can filter by colors or " no fill" and delete the resulting range

[Wanda Almeida]

thanks for your reply, I was fumbling arround and managed to work it out, exactly how you said. NOt htat complicated at all! thanks anyway for your message.