Conditional formatting, Duplicate values

[peterpaul]

Hello all,

I have a little problem highlighting the duplicate values. I have a column that uses vlookup, when it doesn’t find a value, it outputs “”. But every cell that outputs this, is now a duplicate but that’s not what I’m looking for. Is there a solution where the “empty” cells don’t get highlighted?

This is just an example to show you my problem:

Map1
	A	B	C	D	E
1	ID	Number		DB
2	2	2345		1	1234
3	4	2356		2	2345
4	8			3	1245
5	1			4	2356
6	9			5	1256
Blad1

Cell Formulas
Range	Formula
B2:B6	B2	=IFNA(VLOOKUP(A2,D2:E6,2,0), "")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B6	Cell Value	duplicates	text	NO

 

[hrayani]

formula in coditional formatting
=AND(COUNTIF(B:B,B2)>1,LEN(B2)>0)

 

[peterpaul]

Works like a charm, thank you very much

 

[hrayani]

Works like a charm, thank you very much

My Pleasure