Highlighting duplicates using conditional formatting

[Minx_Minxy]

Hi,

I need to highlight duplicates in column A, but only if column B is equal to 10. 68923 10 68923 20 68923 30 68924 10 68924 20 68925 10 68926 10 68927 10 68928 10 68923 <tbody> </tbody> In the example above, what I want it to do is, as soon as I input the value on column A the cell automatically changes colour highlighting only cells A1 and A10. I have tried using sumproduct and countifs on conditional formatting, but it does not highlight the values. Thank you in advance.

<tbody>
</tbody>

 

[konew1]

Excel Workbook
	A	B
1	68923	10
2	68923	20
3	68923	30
4	68924	10
5	68924	20
6	68925	10
7	68926	10
8	68927	10
9	68928	10
10	68923
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A2	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A3	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A4	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A5	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A6	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A7	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A8	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A9	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc
A10	1. / Formula is =AND(COUNTIFS(A:A,A1,B:B,"")>0,COUNTIFS(A:A,A1,B:B,10)>0,B1<=10)	Abc

 

[Minx_Minxy]

Thank you very much! It worked really well!?