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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Function Date Range Issues 6
Copy addition formula of non-consecutive horizontal cells 2
Pasting a cell into bookmarked table from excel vba 1
Need Help with a VBA subroutine 0
Finding the proper style field and the numbered paragraph value within the style 0
AppleScript - How do I select a text ? 1
A find formul looking at two named ranges for two strings 8
conditional if loop 0

Top