Formatting numbers as text but come up as false with istext

[Ramballah]

Hello everyone,

I have a few columns where cells will be formatted as followed:

Some cells have letters in them and some dont. However due to this all the cells formatting is plain text. So if i use =ISTEXT then even the cells with just numbers will come up as true.
I need to mark down the cells that contain letters but by using ISTEXT, the ones without letters will also get marked. I tried multiple ways to use custom formatting but I just couldn't find any results.
Google bare no fruits either. So hopefully someone can help me out.
I should mention this is currently in google spreadsheets but I can also convert it to Excel 360.

Thanks in advance,
Ram

 

[Fluff]

You never said you wanted this in conditional formatting, but the cell reference must match the first row in the applies to range.

 

[Ramballah]

You never said you wanted this in conditional formatting, but the cell reference must match the first row in the applies to range.

That explains it, and yeah it's because I just now thought of having it in conditional formatting after u gave me ur formula. Sorry.

 

[Fluff]

Is it now working?