Conditional Format w/ vlookup????
 

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.

Conditional Format w/ vlookup????
 

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" wrote:

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.

Conditional Format w/ vlookup????
 

Thanks.

"Sheeloo" wrote:

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" wrote:

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.

Conditional Format w/ vlookup????
 

Did it work out for you?

"Jambruins" wrote:

Thanks.

"Sheeloo" wrote:

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" wrote:

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.