Special Characters to be Highlighted

Hi... Currently am using a macro for highlighting cells containing special characters in "L" column. But i need a macro to highlight the cells in one color and the special character in another color in "L" column. This will help me in searching the special character in that cell. Also i need a pop for special character count.


Current Macro as below:

Please Login or Register  to view this content.

Have you tried using :

Please Login or Register  to view this content.

Hi jindon...
1> I have edited my post.
2> Your code works fine, but special characters are need to be replaced by my conditions. can you help in that. Also will be very helpful if we got the count for highlighted character.
conditions are :
(
,
)
\
double space
!
@
#
$
%
^
&
*
home
depot
and,
or,
Space-Space
space-
-space

Hi.. Thanks for your reply.
Can you tel me where i have to insert this code.

Originally Posted by thelisa

Have you tried using :

With Selection.Font
.Color = 'color here
.TintAndShade = 0
End With

A.JPG
I have uploaded a image for better reference.
Cell below A is the result of my current macro. But i need a result as shown in the cell below B

Originally Posted by dhilipan

Hi.. Thanks for your reply.
Can you tel me where i have to insert this code.

Originally Posted by jindon

No idea what you are trying to do.

Post a workbook with before/after format.

A.JPG
I have uploaded a image for better reference.
Cell below A is the result of my current macro. But i need a result as shown in the cell below B

Originally Posted by jindon

Picture doesn't help at all.

I have attached the sample excel file [Original is highly confidential]
I need to verify a column contains special character or not. if found then the cell and the character should be highlighted.

[QUOTE=jindon;3336068]You didn't show AFTER.
Hi Jindon, i dont know how to show you "AFTER" coz i dont have what i need.
My requirement is

Before----------After-------------------Remarks
Find my place |Find my place |double space between the words my and place, that should be highlighted
find -my place |find -my place |Space before "-" need to be highlighted
find - my place |find - my place |Space before and after "-" need to be highlighted

Ok Jindon,
Can you help me in this, need to highlight if the cells in column contains "and," "or,"

Originally Posted by jindon

Huh???

How would I know?


This must be a joke.

No Jindon, "and," Special character "," need to be add to that

Originally Posted by jindon

Already done it in #11.

Hi i need to highlight special character and the cells contains special character. currently am using below macro, but its only highlighting cells and not the special character. Also i need the count of special character by a pop up message.

Please Login or Register  to view this content.

Hello dhilipan,

This will color the special characters red and return the count in the message box.

Please Login or Register  to view this content.

Hi Leith, thanks. but this is not highlighting special characters :-( Also i need to do this in "L" column. I need check this for quality check in large data from others. please help

Originally Posted by Leith Ross

Hello dhilipan,

This will color the special characters red and return the count in the message box.

Please Login or Register  to view this content.

Hi Jindon, i have attached the file, i need result as i sheet 1 and added the characters to be highlighted in sheet 2.

Originally Posted by jindon

I don't want to repeat this again.

"Show me what you have and the result that you want."

Hello dhilipan,

It seems that you are still learning VBA.

I used the great Code which Leith Ross has provided you with, and simply changed the Column references, to work for you in Column L.

In the attached Workbook, I have also provided you with various other ways of how to deal with Special Characters. Play around with it, see how it works, and use what you like.

Also see the "Please consider" note at the bottom of this post.

Hello dhilipan,

You are welcome.

Thank you for adding to my Reputation.

Hope you find the examples usefull.

Hello dabbas555,

We don't know what your workbook looks like, nor what your exact requirement is

Please attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thank you.