Highlight duplicates for case-sensitive matches

[excelguy2024]

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!

 

[Cubist]

Try:

Book1
	A	B
1	site	dare
2	affair	plan
3	hell	finish
4	abandon	improve
5	feign	society
6	say	Venus
7	make	reverse
8	assertive	answer
9	revolutionary	established
10	potential	X-ray
11	overlook	mutter
12		instinct
13		page
14		mole
15		primary
16		ask
17		option
18		soldier
19		ghostwriter
20		declaration
21		SITE
22		AFFAIR
23		HELL
24		ABANDON
25		FEIGN
26		SAY
27		MAKE
28		ASSERTIVE
29		REVOLUTIONARY
30		POTENTIAL
31		OVERLOOK
32		sItE
33		AfFaIr
34		hElL
35		AbAnDoN
36		FeIgN
37		SaY
38		MaKe
39		aSsErTiVe
40		rEvOlUtIoNaRy
41		pOtEnTiAl
42		oVeRlOoK
43		say
44		assertive
45		potential
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B45	Expression	=SUM(--EXACT($A$1:$A$11,B1))>0	text	NO
A1:A11	Expression	=SUM(--EXACT(A1,$B$1:$B$45))>0	text	NO

 

[Joe4]

Ah, I had the order of my ranges reversed when trying to incorporate N0madic's solution!
Thanks for the assist, Cubist!

 

[excelguy2024]

@Cubist Thank you - you're the best!

 

[Cubist]

You're welcome. Glad to assist.