Conditional Formatting for Special characters

[Prashantvk123]

Hi All,

Hope you are doing well.
My question is regarding conditional formatting, I have a column in excel where we have a contract numbers for instance

356
578
783

we get this file from customer and we need to upload it to a query, but in case there are special characters in the data than query will not take that and then we need to manually look for these errors in the file.
I want to use a conditional formatting where if we have these special characters in the data that cell will be highlighted as Red.

hope to have framed the question well...

 

[Luke M]

Assuming that good data = only numbers, you could use a CF rule of:
=ISTEXT(A2)
and apply whatever formatting your desire.
If some good data can contain letters and numbers, could you specify which specific characters are bad?

 

[Prashantvk123]

Thanks a lot for replying, You pointed out correctly and I forgot to mentioned that my data has text as well as numbers, but there is no specific characters that is bad, we get all types of special characters, for e.g. #, $, %, ^, !, * etc

 

[Luke M]

So...alpha and numbers are good, but any symbol is bad?
I think easiest would then be to create a range of all the "Good" characters, since there's only a few, and then we can have our CF compare each character to make sure it's on the list. Check out this example.