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.

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.

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.

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.