conditional formatting

[aarti_rto]

Hi,
I have below data & need to highlight the cells which have duplicate value in "A" as well as "B"&"C" column.
pl suggest.

Location "A"	Material "B"	Qty"C"	Remarks
A1-02-01	AAA	9	formula/condition should highlight this duplicate
b4-03-09	XYZ	31
b4-04-01	ABC	42
A1-02-01	DDD	28
C7-02-04	AAA	15
C7-02-05	XYZ	16	formula/condition should highlight this duplicate
C7-02-05	ABC	30
C7-02-05	XYZ	16	formula/condition should highlight this duplicate
A1-02-01	DDD	10
A1-02-01	AAA	9	formula/condition should highlight this duplicate

 

[GraH]

A simple countifs might do?

Book1
	A	B	C
1	Location	Material	Qty
2	A1-02-01	AAA	9
3	b4-03-09	XYZ	31
4	b4-04-01	ABC	42
5	A1-02-01	DDD	28
6	C7-02-04	AAA	15
7	C7-02-05	XYZ	16
8	C7-02-05	ABC	30
9	C7-02-05	XYZ	16
10	A1-02-01	DDD	10
11	A1-02-01	AAA	9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C11	Expression	=COUNTIFS($A$2:$A$11;$A2;$B$2:$B$11;$B2;$C$2:$C$11;$C2)>1	text	NO