i have an excel document made of up 5 columns and a lot of rows.

how can i check to see if a specific word exists in a row, and if the word
is found, then shade the 5 columns that make up the row a color of my
choice??

thansk for the help