How do I get custom formula conditional formulas to apply to Array results?custom formula conditional formating - Only weekedays and 3 days in futureHow do I get google sheet conditional formatting custom formulas to refer to relative cells?Increment count in column based on value in columnHow to address the current cell in conditional format custom formula?Conditional formatting in Google Sheets: Can I use custom function in the 'custom formula is:' field?Calculate weekly sum in spreadsheet using array formulaHow to reference data from another sheet in a conditional formula in google docsApply conditional formatting to subsequent cells in Google SheetsGoogle Sheets Custom conditional formatting multiple conditionsConditional formatting custom formula based on calculation
Who was president of the USA?
Identify a problem where a potentially winning move draws because of the 50 move rule
Did a flight controller ever answer Flight with a no-go?
Does norwegian.no airline overbook flights?
Thank God it's Friday, tomorrow is THE weekend. Why the definite article?
How to respectfully refuse to assist co-workers with IT issues?
How to find multiple values on the same line in any permutation using Notepad++?
Anatomically Correct Whomping Willow
How is the idea of "two people having a heated argument" idiomatically expressed in German?
Compelling story with the world as a villain
Did the British navy fail to take into account the ballistics correction due to Coriolis force during WW1 Falkland Islands battle?
Why do all fields in a QFT transform like *irreducible* representations of some group?
Shouldn't the "credit score" prevent Americans from going deeper and deeper into personal debt?
What is the difference between Major and Minor Bug?
Is there any method of inflicting the incapacitated condition and no other condition?
How do I get toddlers to stop asking for food every hour?
Is it possible to perform a regression where you have an unknown / unknowable feature variable?
Do they have Supervillain(s)?
How would one country purchase another?
If the first law of thermodynamics ensures conservation of energy, why does it allow systems to lose energy?
Why were the crew so desperate to catch Truman and return him to Seahaven?
Are the players on the same team as the DM?
Can a Rogue PC teach an NPC to perform Sneak Attack?
How do I get a decreased-by-one x in a foreach loop?
How do I get custom formula conditional formulas to apply to Array results?
custom formula conditional formating - Only weekedays and 3 days in futureHow do I get google sheet conditional formatting custom formulas to refer to relative cells?Increment count in column based on value in columnHow to address the current cell in conditional format custom formula?Conditional formatting in Google Sheets: Can I use custom function in the 'custom formula is:' field?Calculate weekly sum in spreadsheet using array formulaHow to reference data from another sheet in a conditional formula in google docsApply conditional formatting to subsequent cells in Google SheetsGoogle Sheets Custom conditional formatting multiple conditionsConditional formatting custom formula based on calculation
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I need to apply conditional formatting to results of an array formula to highlight any result that has the word "Installation" in it.
I have a calendar with Array formula results. I want to highlight anything that contains the word INSTALLATION in the block.
I have used the conditional formatting custom formula of
=find("Installation",$C$2:$G:$55)
but, even though the array formula results contain Installation, the formatting is not applied.
Below is my sheet.
Thanks in advance.
https://docs.google.com/spreadsheets/d/1noCiboVB5_yTq9H0W_-q9goqc4E9Gq0DhcNMuXj9Kz4/edit#gid=286793601
array-formulas google-sheets-formula gs-conditional-formatting
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
add a comment |
I need to apply conditional formatting to results of an array formula to highlight any result that has the word "Installation" in it.
I have a calendar with Array formula results. I want to highlight anything that contains the word INSTALLATION in the block.
I have used the conditional formatting custom formula of
=find("Installation",$C$2:$G:$55)
but, even though the array formula results contain Installation, the formatting is not applied.
Below is my sheet.
Thanks in advance.
https://docs.google.com/spreadsheets/d/1noCiboVB5_yTq9H0W_-q9goqc4E9Gq0DhcNMuXj9Kz4/edit#gid=286793601
array-formulas google-sheets-formula gs-conditional-formatting
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43
add a comment |
I need to apply conditional formatting to results of an array formula to highlight any result that has the word "Installation" in it.
I have a calendar with Array formula results. I want to highlight anything that contains the word INSTALLATION in the block.
I have used the conditional formatting custom formula of
=find("Installation",$C$2:$G:$55)
but, even though the array formula results contain Installation, the formatting is not applied.
Below is my sheet.
Thanks in advance.
https://docs.google.com/spreadsheets/d/1noCiboVB5_yTq9H0W_-q9goqc4E9Gq0DhcNMuXj9Kz4/edit#gid=286793601
array-formulas google-sheets-formula gs-conditional-formatting
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
I need to apply conditional formatting to results of an array formula to highlight any result that has the word "Installation" in it.
I have a calendar with Array formula results. I want to highlight anything that contains the word INSTALLATION in the block.
I have used the conditional formatting custom formula of
=find("Installation",$C$2:$G:$55)
but, even though the array formula results contain Installation, the formatting is not applied.
Below is my sheet.
Thanks in advance.
https://docs.google.com/spreadsheets/d/1noCiboVB5_yTq9H0W_-q9goqc4E9Gq0DhcNMuXj9Kz4/edit#gid=286793601
array-formulas google-sheets-formula gs-conditional-formatting
array-formulas google-sheets-formula gs-conditional-formatting
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
asked Mar 27 at 17:38
InFocusP3InFocusP3
253 bronze badges
253 bronze badges
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43
add a comment |
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43
add a comment |
1 Answer
1
active
oldest
votes
You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.
This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
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%2f55383436%2fhow-do-i-get-custom-formula-conditional-formulas-to-apply-to-array-results%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
You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.
This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
add a comment |
You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.
This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
add a comment |
You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.
This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
You don't actually need to use a custom formula for this. Conditional Formatting has an in-built function to check if the text contains a certain string.
This formula works, but you have to make sure that it takes precedence over your basic formula which colours cells green if they have any type of content. Basically, drag it on top of the list of active conditional formatting rules for your cells.
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
edited Mar 30 at 15:51
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
answered Mar 29 at 16:49
Florian MingesFlorian Minges
5483 silver badges9 bronze badges
5483 silver badges9 bronze badges
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
add a comment |
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
This does not work on the results of an array. It only works if there is actual TEXT entered into the box.
– InFocusP3
Mar 29 at 22:34
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
Then please change sharing settings on your google sheet so that we can access it. It's a bit hard to help you otherwise.
– Florian Minges
Mar 29 at 23:48
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
My apologies on the sharing settings. <docs.google.com/spreadsheets/d/…>
– InFocusP3
Mar 30 at 13:01
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Amended my answer with information on why my solution did not show up in your spreadsheet. Basically, if a cell has multiple conditional formatting rules applied to it and several match their criteria, the one with the highest "priority" (aka highest in the list) gets applied. But the solution that I first posted does apply, even when you use ArrayFormulas.
– Florian Minges
Mar 30 at 15:53
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
Perfect answer. I had no idea that you could alter the priority. Thanks a ton.
– InFocusP3
Mar 31 at 18:19
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%2f55383436%2fhow-do-i-get-custom-formula-conditional-formulas-to-apply-to-array-results%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
We can't access your sheet. Please change sharing settings.
– Florian Minges
Mar 29 at 16:43