Match list of data of header name and High light in colour unmatched data (vb or macro )

[shrinivasmj]

HI,

I Need to match list of data for the Header Name and High Light in Yellow Colour for Unmatched Data for the Row. Need (vb or macro )

Header Name ( METER MAKER )

[TABLE="width: 77"]
<tbody>[TR]
[TD]List of name
[/TD]
[/TR]
[TR]
[TD]LT-LTD[/TD]
[/TR]
[TR]
[TD]LANDIS+GYR[/TD]
[/TR]
[TR]
[TD]ALSTOM[/TD]
[/TR]
[TR]
[TD]INDIAN METERS[/TD]
[/TR]
[TR]
[TD]ISKRA[/TD]
[/TR]
[TR]
[TD]TTL[/TD]
[/TR]
[TR]
[TD]BHEL[/TD]
[/TR]
[TR]
[TD]GENUS[/TD]
[/TR]
[TR]
[TD]RC-ENERGY[/TD]
[/TR]
[TR]
[TD]HAVELLS[/TD]
[/TR]
[TR]
[TD]REMCO[/TD]
[/TR]
[TR]
[TD]SEMS[/TD]
[/TR]
[TR]
[TD]SIMCO[/TD]
[/TR]
[TR]
[TD]ALSTHOM[/TD]
[/TR]
[TR]
[TD]ELYMER[/TD]
[/TR]
[TR]
[TD]SECURE[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]ACTARIS[/TD]
[/TR]
[TR]
[TD]SIEMENS[/TD]
[/TR]
[TR]
[TD]UE[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[JLGWhiz]

More members would respond if the data posted is related to its position in the layout of a worksheet. Otherwise, assumptions would have to be made as to which rows and columns are being dealt with in the code and those assumptions could be far off from actual conditions. It is helpful to post an example of the sheet layout. See the link below:

http://www.mrexcel.com/forum/excel-questions/127080-guidelines-posting-updated-22-nov-2006-a.html

 

[shrinivasmj]

HI,

IF HEADER NAME IN COLUMN 1 ANY WERE FIND ( METER MAKER ) NEED TO
MATCH DATA IN ROW THE LIST AND MARK UNMATCHED DATE AND FILL IN YELLO
COLOUR THE CELL.(vb or macro )

List of name

LT-LTD

LANDIS+GYR

ALSTOM

INDIAN METERS

ISKRA

TTL

BHEL

GENUS

RC-ENERGY

HAVELLS

REMCO

SEMS

SIMCO

ALSTHOM

ELYMER

SECURE

ACTARIS

SIEMENS

UE