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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

hippiehacker

Well-known Member
Joined
Aug 2, 2011
Messages
1,911
where to find in the sheet or within workbook?
and in which range to look for?
 
Last edited:

shrinivasmj

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

shrinivasmj

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

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,119
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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
 

Watch MrExcel Video

Forum statistics

Threads
1,132,676
Messages
5,654,686
Members
418,147
Latest member
dorkas

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
Top