(Msg. 2) Posted: Tue Jun 23, 2009 9:43 am
Post subject: RE: highlighting text [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
yes.
Conditional format with contains and enter your text...
"ganga" wrote:
> I'm attempting to do some conditional formatting on text. I need to
> highlight cells by itself that contain the text .
> is this possible?
>
(Msg. 3) Posted: Tue Jun 23, 2009 2:08 pm
Post subject: RE: highlighting text [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
thank you but the the text is not always same though..i want the cell to be
highlighted what ever i entered in that cell (cell range)
"Sean Timmons" wrote:
> yes. >
> Conditional format with contains and enter your text...
>
> "ganga" wrote:
>
> > I'm attempting to do some conditional formatting on text. I need to
> > highlight cells by itself that contain the text .
> > is this possible?
> >
(Msg. 4) Posted: Sun Jun 28, 2009 11:30 am
Post subject: RE: highlighting text [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not sure I understand what you mean. Are you saying you want to compare your
cell's text against another cell?
In that case, select formlua is from the first drop-down and enter =A2 or
whatever cell has the text to compare.
Or, are you saying if the cell has text, highlight it?
In that case, formulas is... =ISTEXT(A2) where A2 is the cell you are
evaluating.
"ganga" wrote:
> thank you but the the text is not always same though..i want the cell to be
> highlighted what ever i entered in that cell (cell range)
>
> "Sean Timmons" wrote:
>
> > yes. > >
> > Conditional format with contains and enter your text...
> >
> > "ganga" wrote:
> >
> > > I'm attempting to do some conditional formatting on text. I need to
> > > highlight cells by itself that contain the text .
> > > is this possible?
> > >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office