Alternating colors for consecutive groups of events in ExcelAlternating coloring groups of rows in ExcelHow do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Import and Export Excel - What is the best library?How to avoid using Select in Excel VBAAdding color via macro in excelHow can I color dots in a xy scatterplot according to column value?Sorting Rows based on ColorExcel: how to group and then sort groups in a custom order?How to create a program that manipulates excel data to sort ids into categories?Excel checking if row is part of a group
The Purpose of "Natu"
How can a ban from entering the US be lifted?
What can a novel do that film and TV cannot?
Boss furious on bad appraisal
What is this arch-and-tower near a road?
Taking my Ph.D. advisor out for dinner after graduation
Dualizable object in the category of locally presentable categories
How do I check that users don't write down their passwords?
Isn't "Dave's protocol" good if only the database, and not the code, is leaked?
How do I iterate equal values with the standard library?
PhD: When to quit and move on?
Motorcyle Chain needs to be cleaned every time you lube it?
How did Captain Marvel do this without dying?
Was the 45.9°C temperature in France in June 2019 the highest ever recorded in France?
Why do we need a bootloader separate from our application program in microcontrollers?
When is one 'Ready' to make Original Contributions to Mathematics?
Will electrically joined dipoles of different lengths, at right angles, behave as a multiband antenna?
Can a USB hub be used to access a drive from 2 devices?
Find max number you can create from an array of numbers
What is the fundamental difference between catching whales and hunting other animals?
Why do Klingons use cloaking devices?
How serious is plagiarism in a master’s thesis?
What is it called when the tritone is added to a minor scale?
Can you take the Dodge action while prone?
Alternating colors for consecutive groups of events in Excel
Alternating coloring groups of rows in ExcelHow do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?Import and Export Excel - What is the best library?How to avoid using Select in Excel VBAAdding color via macro in excelHow can I color dots in a xy scatterplot according to column value?Sorting Rows based on ColorExcel: how to group and then sort groups in a custom order?How to create a program that manipulates excel data to sort ids into categories?Excel checking if row is part of a group
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have an excel table that looks sort of like this:
I need a way to automatically alternate the row colors. As it stands right now, I have a large list of data that looks like that, but with no grouping.
What I would like is for excel to check the color of the row below a given row, and if that row contains "End of Product", change the color accordingly, in order to demarcate different groups of events.
Thanks!
excel vba
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
add a comment |
I have an excel table that looks sort of like this:
I need a way to automatically alternate the row colors. As it stands right now, I have a large list of data that looks like that, but with no grouping.
What I would like is for excel to check the color of the row below a given row, and if that row contains "End of Product", change the color accordingly, in order to demarcate different groups of events.
Thanks!
excel vba
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
add a comment |
I have an excel table that looks sort of like this:
I need a way to automatically alternate the row colors. As it stands right now, I have a large list of data that looks like that, but with no grouping.
What I would like is for excel to check the color of the row below a given row, and if that row contains "End of Product", change the color accordingly, in order to demarcate different groups of events.
Thanks!
excel vba
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
I have an excel table that looks sort of like this:
I need a way to automatically alternate the row colors. As it stands right now, I have a large list of data that looks like that, but with no grouping.
What I would like is for excel to check the color of the row below a given row, and if that row contains "End of Product", change the color accordingly, in order to demarcate different groups of events.
Thanks!
excel vba
excel vba
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
edited Mar 26 at 7:26
Pᴇʜ
28.5k6 gold badges30 silver badges54 bronze badges
28.5k6 gold badges30 silver badges54 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
asked Mar 25 at 19:22
YaYaYaYaYaYaYaYaYaYaYaYa
81 silver badge4 bronze badges
81 silver badge4 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In conditional formatting use a formula as the rule.
Use this formula:
=ISODD(COUNTIFS($F$1:$F1,"End of Product"))
Pay attention to what is and what is not absolute.
Then apply it to your data range:
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
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
);
);
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%2f55345051%2falternating-colors-for-consecutive-groups-of-events-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
In conditional formatting use a formula as the rule.
Use this formula:
=ISODD(COUNTIFS($F$1:$F1,"End of Product"))
Pay attention to what is and what is not absolute.
Then apply it to your data range:
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
add a comment |
In conditional formatting use a formula as the rule.
Use this formula:
=ISODD(COUNTIFS($F$1:$F1,"End of Product"))
Pay attention to what is and what is not absolute.
Then apply it to your data range:
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
add a comment |
In conditional formatting use a formula as the rule.
Use this formula:
=ISODD(COUNTIFS($F$1:$F1,"End of Product"))
Pay attention to what is and what is not absolute.
Then apply it to your data range:
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
In conditional formatting use a formula as the rule.
Use this formula:
=ISODD(COUNTIFS($F$1:$F1,"End of Product"))
Pay attention to what is and what is not absolute.
Then apply it to your data range:
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
answered Mar 25 at 19:27
Scott CranerScott Craner
97.7k8 gold badges27 silver badges53 bronze badges
97.7k8 gold badges27 silver badges53 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
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.
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%2f55345051%2falternating-colors-for-consecutive-groups-of-events-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
