hi all,
i am doing some task in excel to detect the special character that can cause issue.
i am using conditional formatting with below formula.
"=IFERROR(MIN(FIND(MID(B4,ROW(INDIRECT(""1:""&LEN(B4))),1),'Sheet1'!$A$1)),0)=0"
my issue now is, this formula will also detect foreign language. i dont want foreign language to be highlighted.
Thanks,
Atikah
i am doing some task in excel to detect the special character that can cause issue.
i am using conditional formatting with below formula.
"=IFERROR(MIN(FIND(MID(B4,ROW(INDIRECT(""1:""&LEN(B4))),1),'Sheet1'!$A$1)),0)=0"
my issue now is, this formula will also detect foreign language. i dont want foreign language to be highlighted.
Thanks,
Atikah