Need help on how to highlight duplicate values

**avadakedava** · 04-10-2012, 09:57 AM

Hey everyone,

I have an excel file and it's full of record IDs such as 001E000000BX6Lk. The problem is, the system it comes from is case sensitive, so I also have records like 001E000000BX6LK. Exactly the same but the K is capital in one and small in the other.

I'm trying to split the file in two, so that some are on one file and some on the other. If I say highlight duplicates though, it highlights them all since they're all technically duplicates. Is there a way to highlight it in the way that I want? So for example if I had these 4 records:

001E000000BX6Lk
001E000000BX6LK
001E000000Bd9eu
001E000000Bd9Eu

It would highlight like:

001E000000BX6Lk*highlight
001E000000BX6LK
001E000000Bd9eu*highlight
001E000000Bd9Eu

Is there any way to highlight that way? I need to run these through a service checking tool, and when it exports from that tool it puts everything in capitals. So when I go to re-import this excel file into Salesforce it doesn't know what record belongs to what account since it's changed them all. Thanks!

**bonny24tycoon** · 04-10-2012, 10:13 AM

hi avadakedava,

Yes, there is a way.

1. Select the column in which the data is present.
2. Select Conditional Formatting.
3. Click New Rule.
4. Select the 5th option "Format only unique or duplicate value
5. In the same window select from drop down "Duplicate"
6. Click on format button
7. Click on Fill Tab and select a color.
8. Click Ok

I tried to attach a screenshot Attachment 149637

You should be good then. :-)

If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

**bonny24tycoon** · 04-10-2012, 11:11 AM

Hi avadakedava,

Is your issue resolved?

If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

**avadakedava** · 04-10-2012, 11:27 AM

Didn't seem to work, doing that just highlights the entire column again the same way it does if I pick the normal highlight duplicates. If I pick unique from the drop down instead of duplicate then it highlights nothing.