This may sound like a basic question. But I am trying to set up some
conditional formatting based on varying text in Excel 2003. I am sorting
baseball players and their stats. First I want the cells in the entire row
to be one color if they are on a team listed in column B. Second I want it
to be a different color if the player is not on a team, but is a batter. And
third I want the row to be a different color if the player is a pitcher.
Players names are in column A and two other workbooks have the batters and
pitchers listed separately. I have named the list of each players names
"Batters" and "Pitchers" respectively.

Thus I am using three formulas as follows:

Formula 1 =$B2=Owners
Formula 2 =$A2=Batters
Formula 3 =$A2=Pitchers

For some reason, only row two worked. Anyone have any insight on this? I
cannot select a range on another workbook.