Formatting VBA Needed

[nrguerrieri]

Hello,

So i have an excel table with 9 columns and 10,000 rows. I would like every row in column C to be searched and every cell checks the other cells in column C for any other cell with the same 5 starting characters and then each one that is the same as the other. Those cells have their entire row filled in light grey.

Thanks,

Nick

 

[smozgur]

Excluding the hidden rows from the data validation list is far beyond of my attempt to solve the original question.
However, following article might help to see how SUBTOTAL approach might be used to display only visible cells in the data validation list:

Drop Down from Filtered Excel List - Contextures Blog

Someone asked me how to make a data validation drop down that only shows the visible rows from a filtered list. I created a sample file that shows how you can

contexturesblog.com

Also, instead of a strikethrough. Can we make it so the whole row turns into a green fill?

At the formatting step, you would chose fill instead of font strikethrough as it was explained in the first conditional formatting rule above.

Then I would like to make a last column that says "On-Boarded'". Then for each row that has green fill, the last column will say "Yes". To show we got that business.

You would need more than the solution method I provided here for this. Conditional formatting has nothing to do with altering cell content, but cell's displayed format only.