Conditional Fornmatting Text and numbers

[Wanna Learn]

Hello this is my conditional formating => " " and this works fine except
that when there is a number in the cell it does not work. How can I do this
without having to convert the numbers to text? thanks

 

[Toppers]

If you want to highlight fields which are TEXT i.e. are not blank or numeric
, use:

=TEXT($A1) for your CF

HTH

 

[Toppers]

.... sorry typo ....should have been =ISTEXT($A1)

 

[Wanna Learn]

Hello

I want to highlight the field whether is text or not.

 

[Toppers]

Try:

=NOT(ISBLANK($A1))

Hello

I want to highlight the field whether is text or not.