Color code on another cell if cell has duplicate value

[aayaanmayank]

Hi All,

Can anyone help me with. i have below data, if ID is duplicate then do the green color on next cell else yellow color...

ID	Country name
306560	US
4569087	US
896880	US
896880	KR
9970980	US
9970980	US
423489	US
8076070	US
8858780	US
98724	US

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[etaf]

i would use 2 conditional rules

rule 1 for any duplicate - yellow
=COUNTIF(A2:A11,A2)>1

rule 2 for next cell - green - use and put last in the order
=A2=A1

 

[etaf]

use
=OR(A1=A2,A2=A3)

ID	Country name
306560	US
4569087	US
896880	US
896880	KR
9970980	US
9970980	US
423489	US
8076070	US
8858780	US
4569087	US

<colgroup><col span="2"></colgroup><tbody>
</tbody>

 

[aayaanmayank]

thanks but i need VBA code

 

[etaf]

oh, OK - probably useful to have put that in the subject/title