Conditional Formatting based on an already Conditionally Formatted Column

[FRESHShaZaM]

 

[Fluff]

Select B2 to last row of data & use this formula
=COUNTIFS(A:A,A2,B:B,B2)>1

 

[FRESHShaZaM]

Select B2 to last row of data & use this formula
=COUNTIFS(A:A,A2,B:B,B2)>1

Didn't work, it just highlighted random numbers. :/

 

[Fluff]

How can it highlight random numbers if col B is text?

Book1
	A	B
1
2	1296	tyre
3	1296	tyre
4	1296	wheel
5	1297	wheel
6	1297	tyre
7	1297	wheel
8	1298	truck
9	1299	truck
10	1299	truck
11	1300	truck
Report

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B11	Expression	=COUNTIFS(A:A,A2,B:B,B2)>1	text	NO

 

[FRESHShaZaM]

How can it highlight random numbers if col B is text?

Book1
	A	B
1
2	1296	tyre
3	1296	tyre
4	1296	wheel
5	1297	wheel
6	1297	tyre
7	1297	wheel
8	1298	truck
9	1299	truck
10	1299	truck
11	1300	truck
Report

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B11	Expression	=COUNTIFS(A:A,A2,B:B,B2)>1	text	NO

I'm genuinely sorry, I don't know why I said "numbers." I tried it again, and the only difference now is that yours highlights all duplicates, whereas when I used it, only one of the duplicates was highlights. Although, the duplicated issue is still highlighted. Which is nonetheless, helpful, so thank you.

 

[Fluff]

You're welcome & thanks for the feedback