Macro to highlight a cell that has special charcters and symbol

Hi Gurus,

I have a column of text that has numbers, text and combination of text and numbers, symbols and special chars. i need a macro to highlight a cell only if it has a symbol or special character.

Any hint on what those symbols or special characters are? Or should we guess.

other than text and numbers

I hope you understand how many different types of symbols and special characters there are out there. To have a code look at each one would be a tremendous undertaking. Even if you were to test each character against all 26 letters of the alphabet, 10 numbers, and space/comma/period/apostraphe it would be cumbersome. There may be some way to do it with RegEx but I still think it would be a lengthy process.

I wish you the best of luck in finding a solution to your problem.

Maybe:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

@ John. I was thinking something along the same lines. Can I ask why you chose to create a function rather than encapsulate it all within the subroutine? Also, is the code time consuming when run against a large range (for future knowledge)?

@ stnkynts - I didn't write the AlphaNumeric Function, I chose one from many by googling. I got it from here: http://www.techonthenet.com/excel/fo...phanumeric.php. I only tested it on a small sample, so I don't know how efficient it would be on a large range.