highlighting text
 

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?

highlighting text
 

Possible. REfer the below link for help

Cell value is "text" (within quotes).

http://www.contextures.com/xlCondFormat01.html
--
If this post helps click Yes
---------------
Jacob Skaria


"ganga" wrote:

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?

highlighting text
 

Any text?

CFFormula is: =ISTEXT(A1)

Anything?

CFFormula is: =A1<""


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 06:13:01 -0700, ganga
wrote:

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?

highlighting text
 

Thank you..it really helps

"Gord Dibben" wrote:

Any text?

CFFormula is: =ISTEXT(A1)

Anything?

CFFormula is: =A1<""


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 06:13:01 -0700, ganga
wrote:

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?