Try putting your "condition" inside an IF statement in a helper
cell.......... making the true condition=1 and the false condition=0

Then apply your conditional formatting based on that helper cell being 1 or
0

Vaya con Dios,
Chuck, CABGx3



"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
>
>