Search and format

[John]

How do i search a colum of info and if one of the cells
contain the word CAD in a sentance i then want it to
format the whole row Red?

Any help would be great.

Regards

John

 

[Jason Morin]

1. Press Ctrl+A.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" and put:
=ISNUMBER(FIND("CAD",A1))
4. Press Format button and format as desired.

HTH
Jason
Atlanta, GA

 

[john]

Hi Jason

Thanks for this but I'm not too bright and I cant get this
to work, not sure I explained myself correctly, I have
loads of cells with lots of text in and half way through a
sentence I might have the word CAD in it if this is the
case then I need the whole row to change colour.

Hope you can help.

Regards

John

 

[Jason Morin]

Well, I should have told you use $A1, not A1. But it
should work.

Jason

 

[Lady Layla]

But how do you tell it to color the ENTIRE row vs the cell?


: Well, I should have told you use $A1, not A1. But it
: should work.
:
: Jason
:
: >-----Original Message-----
: >Hi Jason
: >
: >Thanks for this but I'm not too bright and I cant get
: this
: >to work, not sure I explained myself correctly, I have
: >loads of cells with lots of text in and half way through
: a
: >sentence I might have the word CAD in it if this is the
: >case then I need the whole row to change colour.
: >
: >Hope you can help.
: >
: >Regards
: >
: >John
: >>-----Original Message-----
: >>1. Press Ctrl+A.
: >>2. Go to Format > Conditional Formatting
: >>3. Select "Formula Is" and put:
: >> =ISNUMBER(FIND("CAD",A1))
: >>4. Press Format button and format as desired.
: >>
: >>HTH
: >>Jason
: >>Atlanta, GA
: >>
: >>>-----Original Message-----
: >>>How do i search a colum of info and if one of the
: cells
: >>>contain the word CAD in a sentance i then want it to
: >>>format the whole row Red?
: >>>
: >>>Any help would be great.
: >>>
: >>>Regards
: >>>
: >>>John
: >>>.
: >>>
: >>.
: >>
: >.
: >

 

[Gord Dibben]

Layla

See Debra's instructions.

http://www.contextures.on.ca/xlCondFormat02.html

Note the $B2 or, in Jason's case, $A1 to anchor the column.

Gord Dibben Excel MVP