Cell to change color based on multiple conditions and have both conditions work
up vote
0
down vote
favorite
I am creating a traffic light in excel. I want the following things to happen based on value of a different cell and on a range of cells. For example if =(F8:F34 <>"") then I want the cell to be black, if =$M$5<89 then I want this same cell to turn red. The formulas themselves do what I want as long as it is the first rule in conditional formatting, but the second rule will not work. Please advise, per it is driving me crazy! Thanks to anyone who can assist.
conditional-formatting
asked Nov 17 at 3:15
user964584
1
add a comment |
up vote
0
down vote
favorite
I am creating a traffic light in excel. I want the following things to happen based on value of a different cell and on a range of cells. For example if =(F8:F34 <>"") then I want the cell to be black, if =$M$5<89 then I want this same cell to turn red. The formulas themselves do what I want as long as it is the first rule in conditional formatting, but the second rule will not work. Please advise, per it is driving me crazy! Thanks to anyone who can assist.
conditional-formatting
asked Nov 17 at 3:15
user964584
1
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am creating a traffic light in excel. I want the following things to happen based on value of a different cell and on a range of cells. For example if =(F8:F34 <>"") then I want the cell to be black, if =$M$5<89 then I want this same cell to turn red. The formulas themselves do what I want as long as it is the first rule in conditional formatting, but the second rule will not work. Please advise, per it is driving me crazy! Thanks to anyone who can assist.
conditional-formatting
asked Nov 17 at 3:15
user964584
1
I am creating a traffic light in excel. I want the following things to happen based on value of a different cell and on a range of cells. For example if =(F8:F34 <>"") then I want the cell to be black, if =$M$5<89 then I want this same cell to turn red. The formulas themselves do what I want as long as it is the first rule in conditional formatting, but the second rule will not work. Please advise, per it is driving me crazy! Thanks to anyone who can assist.
conditional-formatting
conditional-formatting
asked Nov 17 at 3:15
user964584
1
asked Nov 17 at 3:15
user964584
1
asked Nov 17 at 3:15
user964584
1
asked Nov 17 at 3:15
user964584
1
asked Nov 17 at 3:15
user964584
1
1
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14
add a comment |
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1376148%2fcell-to-change-color-based-on-multiple-conditions-and-have-both-conditions-work%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
The cell that I am trying to color format is P6.
– user964584
Nov 17 at 3:17
Can you show us the Conditional Formatting rules that you have?
– Scott
Nov 17 at 3:30
Scott, the formulas I typed in my question are the formatting rules that I have. I am now trying to figure out how to post the snapshot of the formatting rules to show you.
– user964584
Nov 17 at 4:19
Sorry for not getting back to you. If you can get a screenshot of the “Conditional Formatting Rules Manager”, try to upload it by editing your question and typing Ctrl+G or clicking on the “Image” button (looks like a landscape with mountains). Or just type in what you see in the window (include all four columns). … … … … … … … … … … … … … … … … … But also, please clarify what you want Excel to do. You say “if =(F8:F34 <>"") then I want the cell (P6) to be black; if =$M$5<89 then I want this same cell to turn red.” What do you want to happen if both conditions are true?
– Scott
Nov 19 at 3:14