Numbers conditional formatting based on a different cell in the same row
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # in stock, i.e. you can only build one widget with the parts you have, and red when # required > # in stock, i.e. you can't build any widgets without first ordering parts. The problem is, Numbers seems to only want to take in individual cells in the conditional formatting box. Is there any formula to tell it, say, when in row 10, turn D10 red if B10 > D10, and the same, B12 and D12 for row 12, and so on, without having to go thru and program each row individually? Thanks for the help!
mac worksheet-function spreadsheet iwork-numbers
asked Jan 5 '13 at 7:04
ChrisChris
5581713
add a comment |
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # in stock, i.e. you can only build one widget with the parts you have, and red when # required > # in stock, i.e. you can't build any widgets without first ordering parts. The problem is, Numbers seems to only want to take in individual cells in the conditional formatting box. Is there any formula to tell it, say, when in row 10, turn D10 red if B10 > D10, and the same, B12 and D12 for row 12, and so on, without having to go thru and program each row individually? Thanks for the help!
mac worksheet-function spreadsheet iwork-numbers
asked Jan 5 '13 at 7:04
ChrisChris
5581713
add a comment |
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # in stock, i.e. you can only build one widget with the parts you have, and red when # required > # in stock, i.e. you can't build any widgets without first ordering parts. The problem is, Numbers seems to only want to take in individual cells in the conditional formatting box. Is there any formula to tell it, say, when in row 10, turn D10 red if B10 > D10, and the same, B12 and D12 for row 12, and so on, without having to go thru and program each row individually? Thanks for the help!
mac worksheet-function spreadsheet iwork-numbers
asked Jan 5 '13 at 7:04
ChrisChris
5581713
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # in stock, i.e. you can only build one widget with the parts you have, and red when # required > # in stock, i.e. you can't build any widgets without first ordering parts. The problem is, Numbers seems to only want to take in individual cells in the conditional formatting box. Is there any formula to tell it, say, when in row 10, turn D10 red if B10 > D10, and the same, B12 and D12 for row 12, and so on, without having to go thru and program each row individually? Thanks for the help!
mac worksheet-function spreadsheet iwork-numbers
mac worksheet-function spreadsheet iwork-numbers
asked Jan 5 '13 at 7:04
ChrisChris
5581713
asked Jan 5 '13 at 7:04
ChrisChris
5581713
asked Jan 5 '13 at 7:04
ChrisChris
5581713
asked Jan 5 '13 at 7:04
ChrisChris
5581713
asked Jan 5 '13 at 7:04
ChrisChris
5581713
5581713
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention "to turn a cell" so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
add a comment |
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%2f528427%2fnumbers-conditional-formatting-based-on-a-different-cell-in-the-same-row%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
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention "to turn a cell" so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
add a comment |
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention "to turn a cell" so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
add a comment |
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention "to turn a cell" so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
Created on a Windows machine but I'm hoping not an issue (though your Excel version might be), the image should indicate one way to achieve what I think you are asking for:
You mention "to turn a cell" so Applies to here is to ColumnD only - A:D might be more useful, as may be adding green highlighting for parts where current stock is sufficient to service quantity required up to its ROP.
The formulae in conditional formatting rules use arrays, so no need for the tedious repetition your feared!
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
answered Jan 11 '13 at 23:57
pnutspnuts
5,57032239
5,57032239
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.
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%2f528427%2fnumbers-conditional-formatting-based-on-a-different-cell-in-the-same-row%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
