Condtional formatting - ISTEXT

[ThomP]

Is there a way to change the color of a cell if the cell contains text?

thanks

 

[Bob I]

Use T(ref) and whether or not the result is ""

 

[ThomP]

Could explian further?

If cell A1 has "thom" in it, how do we make it highlight yellow?

 

[T. Valko]

Try this using conditional formatting...

Select cell A1
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=ISTEXT(A1)
Click the Format button
Select the desired style(s)
OK out

 

[Bob I]

First don't use a sig separator if you aren't bottom posting, as it
strips quoted material. Are you changing the requirement to be Specific
text, or just some text as the original question indicated?

It is pretty straight forward.

=T(A1)<>"" for any text
or
=A1="thom" for specific text

 

[Klemen25]

This formulas should of course be inserted into conditional
formatting. Works great!