Hi everyone, I've been struggling with this next request.

Is it possible to color a row with a specific color based on finding a
specific word?
If in row 5 the word engineer shows up I would like to turn the whole row
green. No matter where in row 5 the word shows up. I've tried
=IF(5:5="engineer",MOD(ROW(),2)=1,) and this works only for a word in A5.
I can't seem to use A5:IV5
Any help would be appreciated. Gilles