Caps Sensitive conditional formatting

Question

Hi all,

I use MS Excel 2007 on Win XP.

As part of a large database, I have a column of alpha-numeric text strings, all of which have 15 characters, in column C.  I need to conditionally format these to look for duplicates so that I can remove those as overlapping duplicate records.  I've accomplished this easily enough, but the problem is that there are occasions where the string is almost the same except for the letters' being upper- or lower-case.

If I could find a formula to insert into the conditional formatting dialogue box instead that would capture the difference, for example, between "00U8000000BzbGw" and "00U8000000BzbgW," it would make my life a lot easier.  Does anyone know of a way this could be accomplished?

Thanks in advance,

Terri

Answer 1

Hi,

Try this CF formula with the ranges changed to suit

=SUMPRODUCT((EXACT($C$1:$C$20,C1))*($C$1:$C$20<>""))>1

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 2

Your welcome and thanks for the feedback

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 3

Thank you so much Mike! Even though my entire office and its satellites consider me to be the uncontested expert in excel, I am ever aware of how much I need to learn about it.  Thanks so much for providing me with an answer to ease me many days of frustration!

Terri