Excel for Mac conditional formatting not working (at all)
My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are in shared mode, and all are on my local drive (both hard drive and thumb drive). I made sure no groups of cells were selected on other worksheets. In fact, a new trial file with a very simple data set has only one tab. Whenever I click the Conditional Formatting button, the only thing that happens is the three color window control buttons (red, orange, and green at top left of screen) go gray.
Any help with this appreciated. I use this function frequently.
microsoft-excel
asked Jan 15 at 18:23
SedgeSedge
112
add a comment |
My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are in shared mode, and all are on my local drive (both hard drive and thumb drive). I made sure no groups of cells were selected on other worksheets. In fact, a new trial file with a very simple data set has only one tab. Whenever I click the Conditional Formatting button, the only thing that happens is the three color window control buttons (red, orange, and green at top left of screen) go gray.
Any help with this appreciated. I use this function frequently.
microsoft-excel
asked Jan 15 at 18:23
SedgeSedge
112
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47
add a comment |
My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are in shared mode, and all are on my local drive (both hard drive and thumb drive). I made sure no groups of cells were selected on other worksheets. In fact, a new trial file with a very simple data set has only one tab. Whenever I click the Conditional Formatting button, the only thing that happens is the three color window control buttons (red, orange, and green at top left of screen) go gray.
Any help with this appreciated. I use this function frequently.
microsoft-excel
asked Jan 15 at 18:23
SedgeSedge
112
My Conditional Formatting button stopped working (MacBook Air, MacOS Mojave 10.14.2, Excel 2016). This is true for existing files with the formatting done previously, and new files. None of them are in shared mode, and all are on my local drive (both hard drive and thumb drive). I made sure no groups of cells were selected on other worksheets. In fact, a new trial file with a very simple data set has only one tab. Whenever I click the Conditional Formatting button, the only thing that happens is the three color window control buttons (red, orange, and green at top left of screen) go gray.
Any help with this appreciated. I use this function frequently.
microsoft-excel
microsoft-excel
asked Jan 15 at 18:23
SedgeSedge
112
asked Jan 15 at 18:23
SedgeSedge
112
asked Jan 15 at 18:23
SedgeSedge
112
asked Jan 15 at 18:23
SedgeSedge
112
asked Jan 15 at 18:23
SedgeSedge
112
112
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47
add a comment |
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47
add a comment |
0
active
oldest
votes
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%2f1394641%2fexcel-for-mac-conditional-formatting-not-working-at-all%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f1394641%2fexcel-for-mac-conditional-formatting-not-working-at-all%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
What have you tried so far? It will help us not go over already covered ground
– cybernetic.nomad
Jan 15 at 19:44
Other than rebooting the computer, I don't know what to try. It's hard to understand why clicking a function button would disable the application/window functions (the red, orange, green buttons). The "share" option is disabled. The only other unusual issue is the "open recently used file" option does not work on some files, and sometimes doesn't work at all.
– Sedge
Jan 16 at 0:48
What version number of Excel 2016 for MAC?
– Lee
Jan 16 at 1:00
Version 15.25 (160817)
– Sedge
Jan 16 at 3:47