T
ThomP
Is there a way to change the color of a cell if the cell contains text?
thanks
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
Use T(ref) and whether or not the result is ""
T
ThomP
Could explian further?
If cell A1 has "thom" in it, how do we make it highlight yellow?
If cell A1 has "thom" in it, how do we make it highlight yellow?
T
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
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
B
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
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
K
Klemen25
This formulas should of course be inserted into conditional
formatting. Works great!
formatting. Works great!