Hi!

Select row 5
Conditional Formatting
Formula is: =OR(5:5="engineer")

Biff

>-----Original 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
>
>
>.
>