Put the words in a list, say M1:M10, and use a formula of

=OR(AND($A2<"",SUMPRODUCT(--(ISNUMBER(SEARCH($M$1:$M$10,$A2))))),AND($B2<"",S UMPRODUCT(--(ISNUMBER(SEARCH($M$1:$M$10,$B2))))))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Keep It Simple Stupid" wrote
in message ...
Is there a conditional formatting formula that can format an entire row a
certain way if Column A or Column B contain all or one of the words in a
list.
Basically if either Column A or Column B contain "dog" and/or "cat" and/or
"mouse" and/or ....
then I want the whole row to be flagged/shaded/etc.