I queried a database and need to identify records that contain special characters (anything other than alpha or numeric.) I would like an X to be inserted in column A if any cell on that row contains a special character. I would also like the cell that contains the special character to be marked in some way (highlighted) or test is bold red, etc.
I have uploaded the file. What would work best for this situation?