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)

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

"Teaky" wrote:

Try conditional formatting

"Ernesto" wrote:

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.