Highligted special character word Ex:(sa?s)

[Sarankbm]

Hi Friends,

i have write a word one column one by one.in string between one special character ex: sa?ran, arun/kumar.
i will be highligted that word .what kind of VBA code used. FYI Please find attached to the file

 

[bosco_yip]

Try to use Conditional Formatting as in :



Select A1:A100 >> Conditional Formatting >> New rule >> Use a formula >> formula :

=OR(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)<"a")

>> Format >> cell font color choose "red" >> OK

Regards
Bosco