Searching for each cell in column A over another column in B

[moshiko17]

Hello everyone,
I have 2 columns in Excel which i want to check each row in column A for his identity in column B

For example:
Column A
204345
435643
232435
113435
689842
578324

Column B
5367885
578324
5972589
1234844
204345
478771

You can see that the value "204345" and "578324" in Column A have his identity in column B
if its true, i want to make the font bold in column A. if not, dont make it bold.

Can you help with that?
Thanks!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[D0se]

Alternative solution:
Apply this to the relevant worksheet's code

Please Login or Register  to view this content.

[moshiko17]

WOW guys you are incredible awesome !!
thank you very much for your help.. !!!