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.