Thank you all for your suggestions. Biff's suggestions is the one that hits
the nail on the head.

Gilles
"Gilles Desjardins" wrote in message
...
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