conditional formatting with totals

Good Morning all.

I am working on the enclosed sheet. I need to be able to in col. Y put a (l) or (w) for win or loss and have it look up the team in the sheet and color the cell as shown in the sheet. then I need to find a way to total the points for lost points and won points for each player.here is the issue, the sheet is brought in from a program that actually puts who picked what and for how many points. So without rebuilding it each week i want to be able to just import it into the sheet. Any help would be great.