View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diane Diane is offline
external usenet poster
 
Posts: 96
Default Trouble Finding Duplicate Values with Conditional Formatting

Hi All,

I'm using Excel 2007 and need to locate duplicate values in a column. I'm
using Conditional Formatting Highlight Cells Rules Duplicate Values.
This is picking up SOME of the dupes, but not others. So far as I can tell
the cells that are duplicated are identical to one another in every way. Any
thoughts would be greatly appreciated! Thanks!