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.