Conditional Fornmatting Text and numbers
 

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

Conditional Fornmatting Text and numbers
 

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

=TEXT($A1) for your CF

HTH

"Wanna Learn" wrote:

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

Conditional Fornmatting Text and numbers
 

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

"Toppers" wrote:

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

=TEXT($A1) for your CF

HTH

"Wanna Learn" wrote:

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

Conditional Fornmatting Text and numbers
 

Hello

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

"Toppers" wrote:

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

"Toppers" wrote:

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

=TEXT($A1) for your CF

HTH

"Wanna Learn" wrote:

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

Conditional Fornmatting Text and numbers
 

Try:

=NOT(ISBLANK($A1))

"Wanna Learn" wrote:

Hello

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

"Toppers" wrote:

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

"Toppers" wrote:

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

=TEXT($A1) for your CF

HTH

"Wanna Learn" wrote:

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