| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing spreadsheets question
I am trying to use conditional formatting to compare two spreadsheets, let's
call them sheet 1 and sheet 2. What I want to do is look at each row in column A in sheet one and see if that cell appears in column A in sheet 2 (or any column for that matter, but let's use A as an example here). If that cell also appears in sheet 2, I would like that cell to highlight on sheet 1. I appreciate any help someone can give me in this matter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing spreadsheets | Excel Worksheet Functions | |||
| Comparing two spreadsheets. | New Users to Excel | |||
| Comparing Two Spreadsheets | Excel Discussion (Misc queries) | |||
| comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
| Comparing Spreadsheets | Excel Worksheet Functions | |||
Linear Mode
