Index Match Conditional Formatting using VBA Code

[Abdul28]

Hi All

Please advise on a VBA code which i can use with Index Match for conditional formatting.

my conditional formatting formula is as below

=(Combined!$A2=INDEX(Summary!$A:$A,MATCH(Combined!$A2,Summary!$A:$A,0)))

I want to highlight cells (any colour) if any cell in Column A from the Combined sheet matches Column A in my Summary Sheet.

 

[Abdul28]

these are the 2 sheets named Combined and Summary