CF based on “Same Value” in column
0
I need to highlight rows that contain the same value in column A. Previous threads have been helpful, but I can't find how to format for "Same value". I'm currently using:
=INDIRECT("a"&ROW())=280789
but instead of manually creating rules for each value type, I'm hoping to find a rule to do this for me.
excel
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
add a comment |
0
I need to highlight rows that contain the same value in column A. Previous threads have been helpful, but I can't find how to format for "Same value". I'm currently using:
=INDIRECT("a"&ROW())=280789
but instead of manually creating rules for each value type, I'm hoping to find a rule to do this for me.
excel
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50
add a comment |
0
0
0
I need to highlight rows that contain the same value in column A. Previous threads have been helpful, but I can't find how to format for "Same value". I'm currently using:
=INDIRECT("a"&ROW())=280789
but instead of manually creating rules for each value type, I'm hoping to find a rule to do this for me.
excel
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
I need to highlight rows that contain the same value in column A. Previous threads have been helpful, but I can't find how to format for "Same value". I'm currently using:
=INDIRECT("a"&ROW())=280789
but instead of manually creating rules for each value type, I'm hoping to find a rule to do this for me.
excel
excel
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
edited Nov 20 '18 at 15:38
Darren Bartrup-Cook
13.9k11432
13.9k11432
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
asked Nov 20 '18 at 14:20
Cameron VenturaCameron Ventura
1
1
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50
add a comment |
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50
add a comment |
1 Answer
1
active
oldest
votes
0
- Select column
A(as that's the column used in your code). - On the Home ribbon select
Conditional Formatting. - Select
New Rulefrom the drop-down menu. - Select
Format only unique or duplicate values. - Select duplicate from the drop-down box and format cell to suit.
- Click "OK".
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53395057%2fcf-based-on-same-value-in-column%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
0
- Select column
A(as that's the column used in your code). - On the Home ribbon select
Conditional Formatting. - Select
New Rulefrom the drop-down menu. - Select
Format only unique or duplicate values. - Select duplicate from the drop-down box and format cell to suit.
- Click "OK".
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
add a comment |
0
- Select column
A(as that's the column used in your code). - On the Home ribbon select
Conditional Formatting. - Select
New Rulefrom the drop-down menu. - Select
Format only unique or duplicate values. - Select duplicate from the drop-down box and format cell to suit.
- Click "OK".
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
add a comment |
0
0
0
- Select column
A(as that's the column used in your code). - On the Home ribbon select
Conditional Formatting. - Select
New Rulefrom the drop-down menu. - Select
Format only unique or duplicate values. - Select duplicate from the drop-down box and format cell to suit.
- Click "OK".
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
- Select column
A(as that's the column used in your code). - On the Home ribbon select
Conditional Formatting. - Select
New Rulefrom the drop-down menu. - Select
Format only unique or duplicate values. - Select duplicate from the drop-down box and format cell to suit.
- Click "OK".
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
answered Nov 20 '18 at 15:37
Darren Bartrup-CookDarren Bartrup-Cook
13.9k11432
13.9k11432
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
add a comment |
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
The problem with this approach is all of the values in Column A are duplicates - so everything gets highlighted the same way. This is a sheet documenting open projects. Each project has a project identifier in Column A - and each project has five tasks. I'm hoping to auto-highlight every other project to visually differentiate between projects.
– Cameron Ventura
Nov 20 '18 at 15:49
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
You should edit that into your question. Maybe have a separate sheet listing the project ID and associated colour and use that as a lookup.
– Darren Bartrup-Cook
Nov 20 '18 at 15:56
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53395057%2fcf-based-on-same-value-in-column%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
Highlight the whole row or just the cell containing the duplicate value?
– Darren Bartrup-Cook
Nov 20 '18 at 15:34
The whole row .
– Cameron Ventura
Nov 20 '18 at 15:50