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.