How would I highlight an area in a spreadsheet based on a name found in
column A?

such as ... if the name frog was found in column A .. how would I highlight
through a macro ... col C, D, and E all the rows that have Frog listed in
Column A?