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
worksheet 2
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 |