Highlighting duplicates

[SubBow]

Hi,
I'm looking to highlight duplicates where only 2 rows are duplicated. In the below example, I only want the first and third results highlighted, not the second result in the first column, too, which is how excel will highlight it if I use conditional formatting

cup	8 oz.
cup	16 oz.
cup	8 oz.
plate	12"

 

[bebo021999]

Book1
	A	B	C	D
1	cup	8		=COUNTIFS($A$1:$A$5,$A1,$B$1:$B$5,$B1)>1
2	cup	16
3	cup	8
4	abc	1
5	xyz	2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B5	Expression	=COUNTIFS($A$1:$A$5,$A1,$B$1:$B$5,$B1)>1	text	NO

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You could try Conditional Formatting like this.

24 10 31.xlsm
	A	B
1
2	cup	8 oz.
3	cup	16 oz.
4	cup	8 oz.
5	plate	12"
Dupes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B5	Expression	=COUNTIFS($A$2:$A$5,$A2,$B$2:$B$5,$B2)>1	text	NO