Search and format

J

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
 
J

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
 
J

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
 
L

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
: >>>.
: >>>
: >>.
: >>
: >.
: >
 
Top