unmatch data hight light in colour ,

shrinivasmj

Board Regular
Joined
Aug 29, 2012
Messages
140
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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
where to find in the sheet or within workbook?
and in which range to look for?
 
Last edited:
Upvote 0
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
 
Last edited:
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top