Should be the easiest thing to do...

E

Ernesto

I want to do something very simple but can't seem to automate it...

I want to search a spreadsheet for a specific word, i.e. "Smith", and then
highlight the entire row that that specific word appears in.
 
E

Ernesto

Thanks, but in so far as I am aware, conditional formatting applies only to
cells, not to rows/columns. Is there a way to expand this to rows?
 
E

Ernesto

Thanks, but conditional formatting applies only to cells. Is there a way to
expand this to rows/columns?
 
B

Bob Phillips

Select the whole row and apply CF. If using a formula to refer to a cell,
make the column absolute.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
E

Ernesto

Thanks for all the help, but that won't work either.
I have a spreadsheet that looks like

7-3 3-11 11-7
Monday Smith Nelli Maria
Tuesday George Frank Horner
Wednes Maria Ellen Louis
Thursda George Nelli Cathy
Friday Ellen Smith Frank

but much much bigger...

I want to automatically highlight all the ROWS that have the name "Smith"

How best to do this?

should be easy.... but I can't figure it out!
 
B

Bob Phillips

CF with a formula of

=ISNUMBER(MATCH("Smith",1:1,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top