Apply Conditional Formatting to Duplicates: More than one condition

[pto160]

I have a bank report where I am trying to highlight the duplicates. The highlight duplicates only works for one condition under conditional formatting. How do I get it to work for more than one condition?
In my example, I want to highlight duplicates that are duplicates in the Type column and Order column. For my example, type Sale and order 100 occurs twice and I want to highlight that.

Book1
	A	B	C	D	E
1	Transaction ID	Type	Descrption	Order ID	Order
2	1	sale	Dog	AA1	100
3	2	credit	Dog	BA2	100
4	3	sale	Dog	CA3	100
Sheet1

 

[Peter_SSs]

Try this

23 09 08.xlsm
	A	B	C	D	E
1	Transaction ID	Type	Descrption	Order ID	Order
2	1	sale	Dog	AA1	100
3	2	credit	Dog	BA2	100
4	3	sale	Dog	CA3	100
CF Dupes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E4	Expression	=COUNTIFS($B$2:$B$4,$B2,$E$2:$E$4,$E2)>1	text	NO

 

[pto160]

Absolutely brilliant. Thank you so much. This will really help me identify duplicates and make corrections.

 

[Peter_SSs]

Cheers. Glad to help.