Highlight a range of cells if a single cell contains specific text

Hello All,

I am looking for a way to highlight a range of cells based on the value in a single cell.
Example if cell A1 contains the "DUMP", then to highlight the range A1:F10.
It is similar to what you can do in the conditional formatting, but I could only figure out how to highlight cells based on the text that in each cell. (I couldn't get the whole range to highlight (A1:F10), only cell A1 because it was the only cell that contained "DUMP".
Is there a way to use condtional formatting to highlight the whole range, or am I stuck with single cell highlighting? (I am using Miscrosoft Excel 2010)

Thanks For You Time
Zach

Thanks Jacc,

this works if the word is just "DUMP" is there a way to modify the formula to see if the cell contains the word "DUMP"?
Example: Cell D3 contains the text "Take to the Dump"? (I tried: =($D$3="*DUMP*") I don't know if the "*" wildcard needs to be moved for this to work?
Sorry I didn't mention that the cell would contain more text than a single word.

Hi All,

I figured it out by using the formula: =SEARCH("DUMP",$D$3)>0 instead of a variation using the wildcards like the one in my previous post.
Thanks again!