MATCH a range with values in another column

[hsandeep]

In Table 1 (V53:Y62), I want to put back ground color using CF for those value which EQUALS column MA (MA53:MA62)

Sheet2

	V	W	X	Y	Z	MA

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]52[/TD]
[TD="colspan: 4, align: center"]Table 1[/TD]

[TD="bgcolor: #cacaca, align: center"]53[/TD]
[TD="align: right"]100[/TD]
[TD="bgcolor: #ffff00, align: right"]200[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]678[/TD]

[TD="bgcolor: #ffff00, align: right"]200[/TD]

[TD="bgcolor: #cacaca, align: center"]54[/TD]
[TD="align: right"]456[/TD]
[TD="align: right"]201.12[/TD]
[TD="bgcolor: #ffff00, align: right"]400[/TD]
[TD="align: right"]456[/TD]

[TD="bgcolor: #ffff00, align: right"]400[/TD]

[TD="bgcolor: #cacaca, align: center"]55[/TD]
[TD="bgcolor: #ffff00, align: right"]222[/TD]
[TD="align: right"]128.96[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]123[/TD]

[TD="bgcolor: #ffff00, align: right"]222[/TD]

[TD="bgcolor: #cacaca, align: center"]56[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]158.22[/TD]
[TD="align: right"]256[/TD]
[TD="bgcolor: #ffff00, align: right"]145[/TD]

[TD="bgcolor: #ffff00, align: right"]145[/TD]

[TD="bgcolor: #cacaca, align: center"]57[/TD]
[TD="bgcolor: #ffff00, align: right"]122[/TD]
[TD="align: right"]145.88[/TD]
[TD="align: right"]125.87[/TD]
[TD="bgcolor: #ffff00, align: right"]122[/TD]

[TD="bgcolor: #ffff00, align: right"]122[/TD]

[TD="bgcolor: #cacaca, align: center"]58[/TD]
[TD="align: right"]958.23[/TD]
[TD="align: right"]145.88[/TD]
[TD="align: right"]126.9[/TD]
[TD="bgcolor: #ffff00, align: right"]888[/TD]

[TD="bgcolor: #ffff00, align: right"]888[/TD]

[TD="bgcolor: #cacaca, align: center"]59[/TD]
[TD="align: right"]125.666[/TD]
[TD="align: right"]123.23[/TD]
[TD="align: right"]125.63[/TD]
[TD="bgcolor: #ffff00, align: right"]999[/TD]

[TD="bgcolor: #ffff00, align: right"]999[/TD]

[TD="bgcolor: #cacaca, align: center"]60[/TD]
[TD="align: right"]125.888[/TD]
[TD="align: right"]111.22[/TD]
[TD="bgcolor: #ffff00, align: right"]222[/TD]
[TD="align: right"]125[/TD]

[TD="bgcolor: #ffff00, align: right"]222[/TD]

[TD="bgcolor: #cacaca, align: center"]61[/TD]
[TD="align: right"]999[/TD]
[TD="align: right"]888.99[/TD]
[TD="bgcolor: #ffff00, align: right"]777[/TD]
[TD="align: right"]115[/TD]

[TD="bgcolor: #ffff00, align: right"]777[/TD]

[TD="bgcolor: #cacaca, align: center"]62[/TD]
[TD="bgcolor: #ffff00, align: right"]1000[/TD]
[TD="bgcolor: #ffff00, align: right"]1000[/TD]
[TD="bgcolor: #ffff00, align: right"]1000[/TD]
[TD="bgcolor: #ffff00, align: right"]1000[/TD]

[TD="bgcolor: #ffff00, align: right"]1000[/TD]

</tbody>

How to accomplish?
Thanks in adv

 

[gaz_chops]

Try

=V53=$MA53

 

[zJenkins]

Select cells V53:Y62, go to Conditional formatting, new rule, and in the 'select a rule type' box choose "Use a formula to determine which cells to format. In the Format values where this formula is true box type: =V53=$MA53, then choose how you want to format it by clicking on the [Format] button. Hit OK, and be sure that in the "Applies To" box it says =$V$53:$Y$53.

Let me know how that goes.

 

[hsandeep]

Try

=V53=$MA53

Oops..was is so sim......Thanks for help & sorry to waste your time.

 

[gaz_chops]

Select cells V53:Y62, go to Conditional formatting, new rule, and in the 'select a rule type' box choose "Use a formula to determine which cells to format. In the Format values where this formula is true box type: =IF(V53=$MA53,1,0), then choose how you want to format it by clicking on the [Format] button. Hit OK, and be sure that in the "Applies To" box it says =$V$53:$Y$53.

Let me know how that goes.

You don't need the =if statement, the result of =V53=$MA53 is "True" or "False".

 

[gaz_chops]

You don't need the =if statement, the result of =V53=$MA53 is "True" or "False".

You're welcome, and not a waste of time if it helped.