| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare two or more ranges
How do I locate cells in a range where data is missing or mismatched with
other cells in another range? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare two or more ranges
A simple way for that is to highlight mismatching cells via conditional
formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formatsconditional formattingformula: =A1<G1 Regards, Stefi tywlam ezt *rta: How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare two or more ranges
Thank you.
"Stefi" wrote: A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formatsconditional formattingformula: =A1<G1 Regards, Stefi tywlam ezt *rta: How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare two or more ranges
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated. Stefi tywlam ezt *rta: Thank you. "Stefi" wrote: A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formatsconditional formattingformula: =A1<G1 Regards, Stefi tywlam ezt *rta: How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare ranges | Excel Worksheet Functions | |||
| Using IF to compare ranges | Excel Worksheet Functions | |||
| Compare named ranges | Excel Worksheet Functions | |||
| compare date ranges to set up eq | Excel Worksheet Functions | |||
| Compare ranges different size | Excel Worksheet Functions | |||
Hybrid Mode
