(Excel 2007) I'd like to conditionally format a range of cells based upon
whether or not a sub-string of text is in a particular cell.

I want to highlight a cell (A1 for formula sake) yellow if the word "Player"
is found in another cell (A2 for formula sake).

Possible A2 cell values could be:
- Major League Player {highlight A1}
- Minor League Player {highlight A1}
- This player is not on a roster {highlight A1}
- No results found {no highlight for A1}

What the exact text of A2 is is not a known or consistent set of
pre-determined text strings. It could be "anything".

Thanks,
Jim