| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match Values and Highlite row
Hi all, I have list of 6 digit numbers in Column A of Sheet2 like see
below A …….col 665544 564788 658977 457896 335566 789456 etc…….. I want macro which should match Sheet1 Range("B2:B100") values in Sheet2 Column A values (as shown above) and if value match then do nothing but the value which don’t match then macro should higlight that value cell row in Sheet1 from row B to F. Please can any friend can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
| Match several values in €˜Summary Sheet to several values in €˜Mast | Excel Programming | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
