How to select multiple Conditional Formatting rule in Manage Rules? The 2019 Stack Overflow Developer Survey Results Are InHow to delete a Excel 2016 ghost or invisible macro?Converting IF statements for use in SUMIF/COUNTIF [or conditional formatting] ExcelEXCEL 2016 - Cannot Use TEXT criteria in Conditional Formatting RulesSelect all colored cells from conditional formattingMaximum number of conditional formatting rules in Excel 2016?Excel Conditional Formatting - Multiple Rules/RowsConditional Formatting Rule Not Working on One CellExcel Data Validations corrupt worksheets (when copying?)Copy/Past format with conditionnals rulesConditional formatting rules not applying the same in all ranges w/same rules
I am an eight letter word. What am I?
What is this sharp, curved notch on my knife for?
Why “相同意思的词” is called “同义词” instead of "同意词"？
writing variables above the numbers in tikz picture
"as much details as you can remember"
Why doesn't UInt have a toDouble()?
Is it okay to consider publishing in my first year of PhD?
How to display lines in a file like ls displays files in a directory?
Why couldn't they take pictures of a closer black hole?
Keeping a retro style to sci-fi spaceships?
Star Trek - X-shaped Item on Regula/Orbital Office Starbases
Ubuntu Server install with full GUI
How did passengers keep warm on sail ships?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
How do you keep chess fun when your opponent constantly beats you?
Cooking pasta in a water boiler
Why are there uneven bright areas in this photo of black hole?
Is an up-to-date browser secure on an out-of-date OS?
Why not take a picture of a closer black hole?
Is it possible for absolutely everyone to attain enlightenment?
How to type a long/em dash `—`
Output the Arecibo Message
APIPA and LAN Broadcast Domain
How do I free up internal storage if I don't have any apps downloaded?
How to select multiple Conditional Formatting rule in Manage Rules?
The 2019 Stack Overflow Developer Survey Results Are InHow to delete a Excel 2016 ghost or invisible macro?Converting IF statements for use in SUMIF/COUNTIF [or conditional formatting] ExcelEXCEL 2016 - Cannot Use TEXT criteria in Conditional Formatting RulesSelect all colored cells from conditional formattingMaximum number of conditional formatting rules in Excel 2016?Excel Conditional Formatting - Multiple Rules/RowsConditional Formatting Rule Not Working on One CellExcel Data Validations corrupt worksheets (when copying?)Copy/Past format with conditionnals rulesConditional formatting rules not applying the same in all ranges w/same rules
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
How do I select multiple conditional formatting rules in 'Manage Rules' in Excel?
I can't clear all rules because some are needed but there is a repeating rule that I want to delete which seems to be specified a few times. In Windows I am used to highlighting one thing, then SHIFT and UP arrow or holding down shift key and mouse click to select more than one.
Any help appreciated, its driving me insane!
excel-2016
asked Mar 8 at 10:50
RShomeRShome
4729
add a comment |
How do I select multiple conditional formatting rules in 'Manage Rules' in Excel?
I can't clear all rules because some are needed but there is a repeating rule that I want to delete which seems to be specified a few times. In Windows I am used to highlighting one thing, then SHIFT and UP arrow or holding down shift key and mouse click to select more than one.
Any help appreciated, its driving me insane!
excel-2016
asked Mar 8 at 10:50
RShomeRShome
4729
add a comment |
How do I select multiple conditional formatting rules in 'Manage Rules' in Excel?
I can't clear all rules because some are needed but there is a repeating rule that I want to delete which seems to be specified a few times. In Windows I am used to highlighting one thing, then SHIFT and UP arrow or holding down shift key and mouse click to select more than one.
Any help appreciated, its driving me insane!
excel-2016
asked Mar 8 at 10:50
RShomeRShome
4729
How do I select multiple conditional formatting rules in 'Manage Rules' in Excel?
I can't clear all rules because some are needed but there is a repeating rule that I want to delete which seems to be specified a few times. In Windows I am used to highlighting one thing, then SHIFT and UP arrow or holding down shift key and mouse click to select more than one.
Any help appreciated, its driving me insane!
excel-2016
excel-2016
asked Mar 8 at 10:50
RShomeRShome
4729
asked Mar 8 at 10:50
RShomeRShome
4729
asked Mar 8 at 10:50
RShomeRShome
4729
asked Mar 8 at 10:50
RShomeRShome
4729
asked Mar 8 at 10:50
RShomeRShome
4729
4729
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I didn't need to remove any conditional formatting rules in the end.
For anyone interested I did two things.
1) For the one sheet that was freezing a lot, I ensured the same font was applied throughout the data.
2) I copied all the data from the sheet to a Word Document and then pasted back into the sheet.
Not sure why those worked but they did! The file was two thirds smaller and I didn't have to delete any CF rules.
answered Mar 8 at 13:54
RShomeRShome
4729
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%2f55061620%2fhow-to-select-multiple-conditional-formatting-rule-in-manage-rules%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
I didn't need to remove any conditional formatting rules in the end.
For anyone interested I did two things.
1) For the one sheet that was freezing a lot, I ensured the same font was applied throughout the data.
2) I copied all the data from the sheet to a Word Document and then pasted back into the sheet.
Not sure why those worked but they did! The file was two thirds smaller and I didn't have to delete any CF rules.
answered Mar 8 at 13:54
RShomeRShome
4729
add a comment |
I didn't need to remove any conditional formatting rules in the end.
For anyone interested I did two things.
1) For the one sheet that was freezing a lot, I ensured the same font was applied throughout the data.
2) I copied all the data from the sheet to a Word Document and then pasted back into the sheet.
Not sure why those worked but they did! The file was two thirds smaller and I didn't have to delete any CF rules.
answered Mar 8 at 13:54
RShomeRShome
4729
add a comment |
I didn't need to remove any conditional formatting rules in the end.
For anyone interested I did two things.
1) For the one sheet that was freezing a lot, I ensured the same font was applied throughout the data.
2) I copied all the data from the sheet to a Word Document and then pasted back into the sheet.
Not sure why those worked but they did! The file was two thirds smaller and I didn't have to delete any CF rules.
answered Mar 8 at 13:54
RShomeRShome
4729
I didn't need to remove any conditional formatting rules in the end.
For anyone interested I did two things.
1) For the one sheet that was freezing a lot, I ensured the same font was applied throughout the data.
2) I copied all the data from the sheet to a Word Document and then pasted back into the sheet.
Not sure why those worked but they did! The file was two thirds smaller and I didn't have to delete any CF rules.
answered Mar 8 at 13:54
RShomeRShome
4729
answered Mar 8 at 13:54
RShomeRShome
4729
answered Mar 8 at 13:54
RShomeRShome
4729
answered Mar 8 at 13:54
RShomeRShome
4729
4729
add a comment |
add a comment |
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%2f55061620%2fhow-to-select-multiple-conditional-formatting-rule-in-manage-rules%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
