Is number match for two columns

[Saoirse]

If i look at Worksheet 1 row 2 and I want to view cell in column A and cell in column C then if those both match ANY rows in worksheet 2 I want them to highlight in worksheet 1. Would I just do an isnumber match formula for conditional formatting?

So if I do an =ISNUMBER(MATCH(B1, 'Sheet 1'!A:A,0)) that won't look at both columns. Can I adjust to have it look at two columns and compare to two columns in worksheet 2?

So both cells in selected column ranges in row 9 on worksheet 1 match the selected column ranges in row 5 on worksheet 2. how would I get worksheet 1 to highlight the row since both numbers match?

worksheet 1

amount			identification
10			3456
20			432
34			8756
35			6532
37			9876
46			412
58			865
59			5432
65			9865
35			4321
17			5432
94			764
880			98723
56			654

worksheet 2

amount		identification
58		865
5		87
67		639
764		1469
65		9865
78		3468
45		9876
23		3457
45		87654
65		2346
89		5423
98		88754
543		6532
23		5432

 

[Fluff]

How about

=AND(COUNTIFS(Sheet2!$A:$A,$A2),COUNTIFS(Sheet2!$C:$C,$D2))

 

[Saoirse]

How about

=AND(COUNTIFS(Sheet2!$A:$A,$A2),COUNTIFS(Sheet2!$C:$C,$D2))

Darn it, it didn't work. It just came up false for each one instead of finding matches. I have attempted to download the XL2BB thing, followed all the directions (i actually had to delete the old one because I used to have it) and it won't let me select "mini sheet" so I couldn't copy it over.

I will keep looking for more ideas. I'm just not sure how to make it search and compare :/

 

[Fluff]

It works for me.

Fluff.xlsm
	A	B	C	D	E	F
1	amount			identification
2	10			3456		FALSE
3	20			432		FALSE
4	34			8756		FALSE
5	35			6532		FALSE
6	37			9876		FALSE
7	46			412		FALSE
8	58			865		TRUE
9	59			5432		FALSE
10	65			9865		TRUE
11	35			4321		FALSE
12	17			5432		FALSE
13	94			764		FALSE
14	880			98723		FALSE
15	56			654		FALSE
Sheet1

Cell Formulas
Range	Formula
F2:F15	F2	=AND(COUNTIFS(Sheet2!$A:$A,$A2),COUNTIFS(Sheet2!$C:$C,$D2))

Make sure you don't have calculation set to manual

 

[Saoirse]

It works for me.

Fluff.xlsm
	A	B	C	D	E	F
1	amount			identification
2	10			3456		FALSE
3	20			432		FALSE
4	34			8756		FALSE
5	35			6532		FALSE
6	37			9876		FALSE
7	46			412		FALSE
8	58			865		TRUE
9	59			5432		FALSE
10	65			9865		TRUE
11	35			4321		FALSE
12	17			5432		FALSE
13	94			764		FALSE
14	880			98723		FALSE
15	56			654		FALSE
Sheet1

Cell Formulas
Range	Formula
F2:F15	F2	=AND(COUNTIFS(Sheet2!$A:$A,$A2),COUNTIFS(Sheet2!$C:$C,$D2))

Make sure you don't have calculation set to manual

Sweet! That was it! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.