In column T I have teams names and in column U there is a number (1, 2, 3, or
4) next to each team name. In cells B2:B24 I want each cell to find the team
name in column T and if the number in the corresponding column U cell equals
1 I want it to hightlight the cell green. Any idea how to do this? I used
=VLOOKUP($B$2,$T:$U,2,0)=1 in cell B2 and it worked but I can't copy this
down and I don't want to have to enter this into each cell and then change
the $B$2 to $B$3 and so on. Thanks.