Ascii Characters_COnditional Formating

[ssakthish]

Dear All,

Please help me with the below requirement.

In Range (A:A) I can find few Ascii Characters. I want to apply conditional formating to those which contains Ascii Characters & want to move that Row to a New Worksheet.

It would be great If it is solved.
Please provide me a formula or VBA Code on this. Thanks in advance.

Regards,
Sak.

 

[Teeroy]

Hi Ssakthish, what Ascii characters specifically are you referring to? Most text you'd find on a spreadsheet is an Ascii character. See ASCII Code - The extended ASCII table for a quick reference.

 

[ssakthish]

Hello,

I am referring to Ascii Codes (128-255) and (32 - 127, Excluding, Numerics & Aplhabets, Iphen, Curved Brackets, &, /, ., :.

Thanks.

Regards,
Sak.