compare two or more ranges

T

tywlam

How do I locate cells in a range where data is missing or mismatched with
other cells in another range?

Thanks.
 
S

Stefi

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
Formats>conditional formatting>formula: =A1<>G1

Regards,
Stefi

„tywlam†ezt írta:
 
T

tywlam

Thank you.

Stefi said:
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
Formats>conditional formatting>formula: =A1<>G1

Regards,
Stefi

„tywlam†ezt írta:
Click to expand...
 
S

Stefi

You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Stefi

„tywlam†ezt írta:
 
Top