Trouble Finding Duplicate Values with Conditional Formatting

G

Guest

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!
 
G

Guest

Thanks Barb! That's what it was! I swear I checked for extra spaces, but I
was looking for them in between words or at the start of the cell. I didn't
realize a trailing space would cause a problem. I appreciate your help! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating - by row, not by column (Office 2007) 1
Conditional Formatting Basics 3
error in highlighting duplicate values in excel 1
Excel conditional formatting with Weeknum 4
Help with conditional formatting 4
copy conditional formatting using built in feature? 1
Question about conditional formatting of zeros in Excel 0
Excel 2007 Conditional formatting not refreshing as it did in 2003 1

Top