Home » Forums » Open Source Learning Center » Question and Answer

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

Submitted by shrinivasmj on 22 October, 2012 - 06:56

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

‹ select the first cell containing data after using autofilter I bet no one can answer this STRANGE question! Copy/pasting email account passwords from Excel shows wrong password, but its not ›
»

can you share the sample

Submitted by Ashish Koul on 5 November, 2012 - 16:19.

can you share the sample file

»