Finding Un - Personalized names

Hi All,

Am using excel 2010 containing more than 1 lakh records of employee data. In that I need to find unpersonalized cards. E.G. Test, Sample..Etc.

Have attached sample excel in that only row number 2 and 5 are the valid names. Other names are not yet personalized i am looking for a macro which will highlight those names in the same sheet.

They record count may increase from 1 lakh in the coming days. Hence am looking to automate this

Regards
Shyam

Thanks Sixthsense.


Test, Value,Sample,South,Council this are the few names. I want this to be highlighted.

I do want the name in the single characters to be highlighted e.g i attached in the excel.Also special characters like @,&,% needs to be highlighted.

Hi Shyam,

I tried to reply yesterday, but for some reason I could not get through - since then Sixth Sense has come up with an answer.

I was going to suggest Conditional Formatting!

Simply create a list of the "Test" words etc on a separate sheet called List.

Then, use this Conditional Formatting formula:

Please Login or Register  to view this content.

I hope this helps, please let me know!

Shyam Sundar - UnPersonalised Names.xlsx

Regards,


David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.