I have a conditional formating formula that highlights duplicate entries.
=COUNTIF($E$2:$E$5000,E1)>1
How can I hide cells which aren't duplicates?