Conditional Format w/ vlookup????

[Jambruins]

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.

 

[Sheeloo]

You CAN ...
Just change $B$2 to B2 before copying

If you are using this in conditional formatting then select the Range B2:B24
then enter the formula as
=VLOOKUP(B2,$T:$U,2,0)=1

If you want to highlight the whole row then select the range and use
=VLOOKUP($B2,$T:$U,2,0)=1

 

[Jambruins]

Thanks.

You CAN ...
Just change $B$2 to B2 before copying

If you are using this in conditional formatting then select the Range B2:B24
then enter the formula as
=VLOOKUP(B2,$T:$U,2,0)=1

If you want to highlight the whole row then select the range and use
=VLOOKUP($B2,$T:$U,2,0)=1

 

[Sheeloo]

Did it work out for you?

Thanks.