Is there a way to colour rows that have an idetical value?
Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same?
So something like this
microsoft-excel colors conditional-formatting
asked Dec 10 at 13:18
klippy
1
add a comment |
Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same?
So something like this
microsoft-excel colors conditional-formatting
asked Dec 10 at 13:18
klippy
1
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37
add a comment |
Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same?
So something like this
microsoft-excel colors conditional-formatting
asked Dec 10 at 13:18
klippy
1
Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same?
So something like this
microsoft-excel colors conditional-formatting
microsoft-excel colors conditional-formatting
asked Dec 10 at 13:18
klippy
1
asked Dec 10 at 13:18
klippy
1
edited Dec 10 at 13:26
asked Dec 10 at 13:18
klippy
1
asked Dec 10 at 13:18
klippy
1
asked Dec 10 at 13:18
klippy
1
1
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37
add a comment |
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37
add a comment |
1 Answer
1
active
oldest
votes
From the article
How to color duplicate values or duplicate rows in Excel?
Color the duplicate values
- Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the dialog, select the color for highlighting duplicates
- Click OK.
Color duplicate rows in the selected range
Select the data range and click Home > Conditional Formatting > New Rule
Then in the New Formatting Rule dialog, select
Use a formula to determine which cells to format in the section of
Select a Rule Type:, then type this formula to the text box under
Format values where this formula is true:
=COUNTIF($D$2:$D$10,$D2)>1
(D2:D10 is the column range you find duplicates from, and D2 is the first cell of the column range)
Click Format to go to the Format Cells dialog, and under the Fill tab,
select a color for the duplicates.Click OK twice.
You may find more details and screenshots in the article.
answered Dec 10 at 13:50
harrymc
253k12259560
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%2f1382321%2fis-there-a-way-to-colour-rows-that-have-an-idetical-value%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
From the article
How to color duplicate values or duplicate rows in Excel?
Color the duplicate values
- Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the dialog, select the color for highlighting duplicates
- Click OK.
Color duplicate rows in the selected range
Select the data range and click Home > Conditional Formatting > New Rule
Then in the New Formatting Rule dialog, select
Use a formula to determine which cells to format in the section of
Select a Rule Type:, then type this formula to the text box under
Format values where this formula is true:
=COUNTIF($D$2:$D$10,$D2)>1
(D2:D10 is the column range you find duplicates from, and D2 is the first cell of the column range)
Click Format to go to the Format Cells dialog, and under the Fill tab,
select a color for the duplicates.Click OK twice.
You may find more details and screenshots in the article.
answered Dec 10 at 13:50
harrymc
253k12259560
add a comment |
From the article
How to color duplicate values or duplicate rows in Excel?
Color the duplicate values
- Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the dialog, select the color for highlighting duplicates
- Click OK.
Color duplicate rows in the selected range
Select the data range and click Home > Conditional Formatting > New Rule
Then in the New Formatting Rule dialog, select
Use a formula to determine which cells to format in the section of
Select a Rule Type:, then type this formula to the text box under
Format values where this formula is true:
=COUNTIF($D$2:$D$10,$D2)>1
(D2:D10 is the column range you find duplicates from, and D2 is the first cell of the column range)
Click Format to go to the Format Cells dialog, and under the Fill tab,
select a color for the duplicates.Click OK twice.
You may find more details and screenshots in the article.
answered Dec 10 at 13:50
harrymc
253k12259560
add a comment |
From the article
How to color duplicate values or duplicate rows in Excel?
Color the duplicate values
- Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the dialog, select the color for highlighting duplicates
- Click OK.
Color duplicate rows in the selected range
Select the data range and click Home > Conditional Formatting > New Rule
Then in the New Formatting Rule dialog, select
Use a formula to determine which cells to format in the section of
Select a Rule Type:, then type this formula to the text box under
Format values where this formula is true:
=COUNTIF($D$2:$D$10,$D2)>1
(D2:D10 is the column range you find duplicates from, and D2 is the first cell of the column range)
Click Format to go to the Format Cells dialog, and under the Fill tab,
select a color for the duplicates.Click OK twice.
You may find more details and screenshots in the article.
answered Dec 10 at 13:50
harrymc
253k12259560
From the article
How to color duplicate values or duplicate rows in Excel?
Color the duplicate values
- Select the data range you want to color the duplicate values, then click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the dialog, select the color for highlighting duplicates
- Click OK.
Color duplicate rows in the selected range
Select the data range and click Home > Conditional Formatting > New Rule
Then in the New Formatting Rule dialog, select
Use a formula to determine which cells to format in the section of
Select a Rule Type:, then type this formula to the text box under
Format values where this formula is true:
=COUNTIF($D$2:$D$10,$D2)>1
(D2:D10 is the column range you find duplicates from, and D2 is the first cell of the column range)
Click Format to go to the Format Cells dialog, and under the Fill tab,
select a color for the duplicates.Click OK twice.
You may find more details and screenshots in the article.
answered Dec 10 at 13:50
harrymc
253k12259560
edited Dec 10 at 13:59
answered Dec 10 at 13:50
harrymc
253k12259560
answered Dec 10 at 13:50
harrymc
253k12259560
answered Dec 10 at 13:50
harrymc
253k12259560
253k12259560
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1382321%2fis-there-a-way-to-colour-rows-that-have-an-idetical-value%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
You can use Conditional Formatting but if your data is large you should provide your data sample.
– Lee
Dec 11 at 1:37