I have a giant list of emails that I need to clean up, and I'd like to do it
by highlighing the duplicates. I use the conditional formatting tool, and it
only works for some. I can clearly see duplicates that it isn't
highlighting, though it will for others. It is just text, not merged or
hyperlinked or formatted any different. For the duplicates it doesn't
highlight, I can copy one dup and "find" (ctrl + f) the other. If it can
"find" both duplicates, and it will highlight others, why doesn't it work
consistently??