highlighting text

[ganga]

I'm attempting to do some conditional formatting on text. I need to
highlight cells by itself that contain any text in the cell .
is this possible?

 

[Jacob Skaria]

Possible. REfer the below link for help

Cell value is "text" (within quotes).

http://www.contextures.com/xlCondFormat01.html

 

[Gord Dibben]

Any text?

CF>Formula is: =ISTEXT(A1)

Anything?

CF>Formula is: =A1<>""


Gord Dibben MS Excel MVP

 

[ganga]

Thank you..it really helps

Any text?

CF>Formula is: =ISTEXT(A1)

Anything?

CF>Formula is: =A1<>""


Gord Dibben MS Excel MVP