Condtional formatting - ISTEXT

  • Thread starter Thread starter ThomP
  • Start date Start date
T

ThomP

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

thanks
 
Could explian further?

If cell A1 has "thom" in it, how do we make it highlight yellow?
 
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
 
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
 
This formulas should of course be inserted into conditional
formatting. Works great!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy condtional formatting in XL2007 for Windows 1
Problem with ISTEXT() 3
Not copying conditional formats 3
Populate cell with multiple non-blank text values 3
PLEASE HELP!!! I cant convert a cell to text for some reason. 1
Conditional Format text Excel 2003 2
Conditional Formatting Question 3
Condtional Formatting - Inserting Rows 1

Back
Top