highlighting text

ganga · Jun 24, 2009

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 · Jun 24, 2009

Possible. REfer the below link for help

Cell value is "text" (within quotes).

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

Gord Dibben · Jun 24, 2009

Any text?

CF>Formula is: =ISTEXT(A1)

Anything?

CF>Formula is: =A1<>""

Gord Dibben MS Excel MVP

ganga · Jun 26, 2009

Thank you..it really helps

Gord Dibben said:
Any text?

CF>Formula is: =ISTEXT(A1)

Anything?

CF>Formula is: =A1<>""

Gord Dibben MS Excel MVP