Highlight the cells being compared in EXACT function in excel
I have an excel spreadsheet containing two columns.
I use the EXACT function to determine if, for example if A2.equals(B2).
The function returns true/false in another cell.
However, I am looking to highlight the original cell that matches/do not match. In this case if A2.equals(B2) evaluates to false, the cells being checked, A2 and B2, are highlighted, how would I go about doing this?
microsoft-excel
asked Jan 4 at 8:37
CarreinCarrein
1,332517
add a comment |
I have an excel spreadsheet containing two columns.
I use the EXACT function to determine if, for example if A2.equals(B2).
The function returns true/false in another cell.
However, I am looking to highlight the original cell that matches/do not match. In this case if A2.equals(B2) evaluates to false, the cells being checked, A2 and B2, are highlighted, how would I go about doing this?
microsoft-excel
asked Jan 4 at 8:37
CarreinCarrein
1,332517
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44
add a comment |
I have an excel spreadsheet containing two columns.
I use the EXACT function to determine if, for example if A2.equals(B2).
The function returns true/false in another cell.
However, I am looking to highlight the original cell that matches/do not match. In this case if A2.equals(B2) evaluates to false, the cells being checked, A2 and B2, are highlighted, how would I go about doing this?
microsoft-excel
asked Jan 4 at 8:37
CarreinCarrein
1,332517
I have an excel spreadsheet containing two columns.
I use the EXACT function to determine if, for example if A2.equals(B2).
The function returns true/false in another cell.
However, I am looking to highlight the original cell that matches/do not match. In this case if A2.equals(B2) evaluates to false, the cells being checked, A2 and B2, are highlighted, how would I go about doing this?
microsoft-excel
microsoft-excel
asked Jan 4 at 8:37
CarreinCarrein
1,332517
asked Jan 4 at 8:37
CarreinCarrein
1,332517
asked Jan 4 at 8:37
CarreinCarrein
1,332517
asked Jan 4 at 8:37
CarreinCarrein
1,332517
asked Jan 4 at 8:37
CarreinCarrein
1,332517
1,332517
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44
add a comment |
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44
add a comment |
1 Answer
1
active
oldest
votes
As mentioned already, you need to use conditional formatting:
- select the range where you want to highlight the values (columns A & B in your example)
- go to home - conditional formatting - new rule
- select "use a formula to determine which cells to format
- enter formula:
=NOT(EXACT($A2,$B2))
note: row number need to be the row number of the active cell A2 in the example, you can check it in the address bar
- click format and set your desired highlight style
- press ok
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f1390426%2fhighlight-the-cells-being-compared-in-exact-function-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
As mentioned already, you need to use conditional formatting:
- select the range where you want to highlight the values (columns A & B in your example)
- go to home - conditional formatting - new rule
- select "use a formula to determine which cells to format
- enter formula:
=NOT(EXACT($A2,$B2))
note: row number need to be the row number of the active cell A2 in the example, you can check it in the address bar
- click format and set your desired highlight style
- press ok
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
add a comment |
As mentioned already, you need to use conditional formatting:
- select the range where you want to highlight the values (columns A & B in your example)
- go to home - conditional formatting - new rule
- select "use a formula to determine which cells to format
- enter formula:
=NOT(EXACT($A2,$B2))
note: row number need to be the row number of the active cell A2 in the example, you can check it in the address bar
- click format and set your desired highlight style
- press ok
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
add a comment |
As mentioned already, you need to use conditional formatting:
- select the range where you want to highlight the values (columns A & B in your example)
- go to home - conditional formatting - new rule
- select "use a formula to determine which cells to format
- enter formula:
=NOT(EXACT($A2,$B2))
note: row number need to be the row number of the active cell A2 in the example, you can check it in the address bar
- click format and set your desired highlight style
- press ok
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
As mentioned already, you need to use conditional formatting:
- select the range where you want to highlight the values (columns A & B in your example)
- go to home - conditional formatting - new rule
- select "use a formula to determine which cells to format
- enter formula:
=NOT(EXACT($A2,$B2))
note: row number need to be the row number of the active cell A2 in the example, you can check it in the address bar
- click format and set your desired highlight style
- press ok
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
answered Jan 4 at 9:03
Máté JuhászMáté Juhász
14.4k63351
14.4k63351
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f1390426%2fhighlight-the-cells-being-compared-in-exact-function-in-excel%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
Just use conditional formatting in the cells you want to format, and use the rules there you want. The fact that something is doing another comparison in another cell doesn't affect that.
– fixer1234
Jan 4 at 8:44