Conditional Format to match values from Sheet 2 to Sheet 1

[chriscorpion786]

Hi All,

How can I use conditional formatting to highlight Column B and Column C values to match the same from Sheet2 to Sheet1.
The values will be same, but I need to highlight in yellow matching values from Sheet2 to Sheet1 as per below.

Many thanks
Mustafa

 

[etaf]

countifs()
=Countifs(Sheet2!$A$2:$A$2000 , sheet1!$A2, Sheet2!$B$2:$B$2000 , sheet1!$B2, Sheet2!$C$2:$C$2000 , sheet1!$C2)>0

change the 2000 to whatever rows you need

sheet1

Book1
	A	B	C
1	Desc	trans	Val
2	1	2	3
3	4	5	6
4	4	5	6
5	7	8	9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C5	Expression	=COUNTIFS(Sheet2!$A$2:$A$2000, $A2, Sheet2!$B$2:$B$2000, $B2, Sheet2!$C$2:$C$2000, $C2)>0	text	NO

Sheet2

Book1
	A	B	C
1	Desc	trans	Val
2	1	2	4
3	4	5	6
4	4	5	6
5	7	8	3
Sheet2

 

[chriscorpion786]

Yes, Thank you works...

 

[etaf]

you are welcome