unmatch data hight light in colour ,

[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

 

[hippiehacker]

where to find in the sheet or within workbook?
and in which range to look for?

 

[shrinivasmj]

hi,

need to find header name by list from a1 to am1 and search for unmatch data in row and high light unmatch data in colour

 

[hippiehacker]

hi,

need to find header name by list from a1 to am1 and search for unmatch data in row and high light unmatch data in colour

look at Find value in Range, Sheet or Sheets with VBA this should get you started

 

[shrinivasmj]

need to find ( METER MAKER ) header name from a1 to am1 and search for unmatch data for ( METER MAKER ) the data list in row and high light unmatch data in colour .(<acronym title="vBulletin">vb</acronym> or macro )



List of data

LT-LTD

LANDIS+GYR

ALSTOM

INDIAN METERS

ISKRA

TTL

BHEL

GENUS

RC-ENERGY

HAVELLS

REMCO

SEMS

SIMCO

ALSTHOM

ELYMER

SECURE

ACTARIS

SIEMENS

UE

 

[MARK858]

Other than the searching for the title why do you need to use a macro when you can do it easy enough using conditional formatting?

The formula would be

=COUNTIF(MyL,C1)<1

where MyL would be your list and C1 would be the first cell in your data