Highlight duplicates for case-sensitive matches

excelguy2024

New Member
Joined
Jun 17, 2024
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hello,

Is there a way to make conditional formatting case sensitive?

I want to highlight the duplicate values in Column A and Column B. When I currently do this, all duplicates are highlighted regardless of their case. I want the exact matches only to be highlighted.

Thanks!
 
Try:
Book1
AB
1sitedare
2affairplan
3hellfinish
4abandonimprove
5feignsociety
6sayVenus
7makereverse
8assertiveanswer
9revolutionaryestablished
10potentialX-ray
11overlookmutter
12instinct
13page
14mole
15primary
16ask
17option
18soldier
19ghostwriter
20declaration
21SITE
22AFFAIR
23HELL
24ABANDON
25FEIGN
26SAY
27MAKE
28ASSERTIVE
29REVOLUTIONARY
30POTENTIAL
31OVERLOOK
32sItE
33AfFaIr
34hElL
35AbAnDoN
36FeIgN
37SaY
38MaKe
39aSsErTiVe
40rEvOlUtIoNaRy
41pOtEnTiAl
42oVeRlOoK
43say
44assertive
45potential
Sheet2
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B1:B45Expression=SUM(--EXACT($A$1:$A$11,B1))>0textNO
A1:A11Expression=SUM(--EXACT(A1,$B$1:$B$45))>0textNO
 
Upvote 0
Solution

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Ah, I had the order of my ranges reversed when trying to incorporate N0madic's solution!
Thanks for the assist, Cubist!
 
Upvote 0

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top