Thread: Identify identical cells of a column

Hello, Infact I would like to identify the cells in duplicate in the same column (max of about 1500 cells) and colorize these duplicates. The cells are characters and not numbers. I think it's pretty simple but I can not and I started the VB in excel
Thank you for your help.

Hello, Why simple when you can make it complicated? Eh!
A simple conditional formatting can do that: For column A that gives: NB.SI = (A: A, A1)> 1 If you really want it through VBA macro you record the same time you do the MFC and you will have a basis to work after YAPUKA optimize .top is not good I'll admit, but as with coughing detail that's all I can do for you!

Good infact I did a lot simpler. I actually made a conditional format that looks duplicates and I just select the column before.
So thank you for your help and for all what you do on this forum