Should be the easiest thing to do...

[Guest]

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.

 

[Guest]

Try conditional formatting

 

[Guest]

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?

 

[Guest]

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

 

[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)

 

[Guest]

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!

 

[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)