Compare 2 columns with 2 conditions and highlight if values are equal
up vote
0
down vote
favorite
I have this kind of spreadsheet in Google Sheets which is used to compare what was ordered and was delivered by delivery company.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQbxS-qQbF1eYPZrdoSf5PI7N-9Hoex4rFZBynkb41esY4gY3FzYP8vZ9gETOemkcODu4lpKoJJk0VU/pubhtml
There are problems there. Products are not in the same alphabetical order and order of them cannot be changed. This is causing me a problem because I cannot compare if quantity of the products is the same because I just can't create such a reference.
I can find if this product is available on second column using MATCH and highlight them using conditional formating but only for cell values from 1 column. This is way beyond my skill to compare 2 columns to different 2 columns.
I will be very grateful for any advice how to create such complicated sheets.
Found solution in the different part of the internet and if You will copy this sheet from url to Your documents then it will work as it intended.
worksheet-function comparison highlighting
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
I have this kind of spreadsheet in Google Sheets which is used to compare what was ordered and was delivered by delivery company.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQbxS-qQbF1eYPZrdoSf5PI7N-9Hoex4rFZBynkb41esY4gY3FzYP8vZ9gETOemkcODu4lpKoJJk0VU/pubhtml
There are problems there. Products are not in the same alphabetical order and order of them cannot be changed. This is causing me a problem because I cannot compare if quantity of the products is the same because I just can't create such a reference.
I can find if this product is available on second column using MATCH and highlight them using conditional formating but only for cell values from 1 column. This is way beyond my skill to compare 2 columns to different 2 columns.
I will be very grateful for any advice how to create such complicated sheets.
Found solution in the different part of the internet and if You will copy this sheet from url to Your documents then it will work as it intended.
worksheet-function comparison highlighting
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have this kind of spreadsheet in Google Sheets which is used to compare what was ordered and was delivered by delivery company.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQbxS-qQbF1eYPZrdoSf5PI7N-9Hoex4rFZBynkb41esY4gY3FzYP8vZ9gETOemkcODu4lpKoJJk0VU/pubhtml
There are problems there. Products are not in the same alphabetical order and order of them cannot be changed. This is causing me a problem because I cannot compare if quantity of the products is the same because I just can't create such a reference.
I can find if this product is available on second column using MATCH and highlight them using conditional formating but only for cell values from 1 column. This is way beyond my skill to compare 2 columns to different 2 columns.
I will be very grateful for any advice how to create such complicated sheets.
Found solution in the different part of the internet and if You will copy this sheet from url to Your documents then it will work as it intended.
worksheet-function comparison highlighting
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have this kind of spreadsheet in Google Sheets which is used to compare what was ordered and was delivered by delivery company.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQbxS-qQbF1eYPZrdoSf5PI7N-9Hoex4rFZBynkb41esY4gY3FzYP8vZ9gETOemkcODu4lpKoJJk0VU/pubhtml
There are problems there. Products are not in the same alphabetical order and order of them cannot be changed. This is causing me a problem because I cannot compare if quantity of the products is the same because I just can't create such a reference.
I can find if this product is available on second column using MATCH and highlight them using conditional formating but only for cell values from 1 column. This is way beyond my skill to compare 2 columns to different 2 columns.
I will be very grateful for any advice how to create such complicated sheets.
Found solution in the different part of the internet and if You will copy this sheet from url to Your documents then it will work as it intended.
worksheet-function comparison highlighting
worksheet-function comparison highlighting
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 14 at 13:42
asked Nov 14 at 9:32
Eryk Wróbel
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 14 at 9:32
Eryk Wróbel
11
asked Nov 14 at 9:32
Eryk Wróbel
11
11
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Eryk Wróbel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Eryk Wróbel is a new contributor. Be nice, and check out our Code of Conduct.
Eryk Wróbel is a new contributor. Be nice, and check out our Code of Conduct.
Eryk Wróbel is a new contributor. Be nice, and check out our Code of Conduct.
Eryk Wróbel is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375250%2fcompare-2-columns-with-2-conditions-and-highlight-if-values-are-equal%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
