conditional formating rule

[ericlch16]

I have two column A B
aa bb
rr tt

I have another column D E
aa bb
rr uu

I want A1 to turn red when A & B is equal D & E. in the example above only A1 will turn red. A2 will not turn red since B2 does not match E2

what is the conditional formatting rule to be inserted? if it is only one column, i can use vlookup but i have to match two columns?

 

[VoG]

Try

=AND(A1=D1,B1=E1)

 

[ericlch16]

i forgot to mention that it might not be in order

So if two column A B
rr tt
aa bb


I have another column D E
aa bb
rr uu

A2 should turn red.....

I have two column A B
aa bb
rr tt

I have another column D E
aa bb
rr uu

I want A1 to turn red when A & B is equal D & E. in the example above only A1 will turn red. A2 will not turn red since B2 does not match E2

what is the conditional formatting rule to be inserted? if it is only one column, i can use vlookup but i have to match two columns?

 

[VoG]

Maybe

=AND(ISNUMBER(MATCH(A1,D:D,0)),ISNUMBER(MATCH(B1,E:E,0)),MATCH(A1,D:D,0)=MATCH(B1,E:E,0))

 

[ericlch16]

does not work

A6: 02-Aug-XX0001-9010
B6: -1

D3: 02-Aug-XX0001-9010
E3: -1

I want A6 to turn red as there is a perfect match on row 3 [D & E]

=AND(ISNUMBER(MATCH(A6,D:D,0)),ISNUMBER(MATCH(B6,E:E,0)),MATCH(A6,D:D,0)=MATCH(B6,E:E,0)) ???

Maybe

=AND(ISNUMBER(MATCH(A1,D:D,0)),ISNUMBER(MATCH(B1,E:E,0)),MATCH(A1,D:D,0)=MATCH(B1,E:E,0))

 

[VoG]

Working with your original example data

Excel Workbook
	A	B	C	D	E
1	rr	tt		aa	bb
2	aa	bb		rr	uu
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =AND(ISNUMBER(MATCH(A1,D:D,0)),ISNUMBER(MATCH(B1,E:E,0)),MATCH(A1,D:D,0)=MATCH(B1,E:E,0))	Abc