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

Gilles
"Gilles Desjardins" <gilles.desjardins3@sympatico.ca> wrote in message
news:HAcPd.33752$Ub4.1424234@news20.bellglobal.com...
> 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
>