| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Worksheet Values
I have two worksheets sheet1 and sheet2. Each cells in the worksheets are text values. Sheet1 range of cells is (A1:A1677) and sheet2 range of cells is (A1:A822). I would like to see if the values in sheet2 are listed in sheet1. If the value is found in sheet1 then color that cell background yellow. Compare each cell value in sheet2 against sheet1. Please help me create a Excel VB macro to complete this task. Thank You, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
| Compare Listbox values with Collection values | Excel Programming | |||
| compare values between workbooks and copy values | Excel Programming | |||
Threaded Mode
