Conditional format to show text based on specific valuesHow to prevent Excel rounding numbers or adding...
How could an airship be repaired midflight?
What's the meaning of a knight fighting a snail in medieval book illustrations?
Instead of a Universal Basic Income program, why not implement a "Universal Basic Needs" program?
Can I use USB data pins as power source
Is "upgrade" the right word to use in this context?
Why does overlay work only on the first tcolorbox?
Why do newer 737s use two different styles of split winglets?
Unable to evaluate Eigenvalues and Eigenvectors for a matrix (2)
My adviser wants to be the first author
A diagram about partial derivatives of f(x,y)
What are substitutions for coconut in curry?
Violin - Can double stops be played when the strings are not next to each other?
Simplify an interface for flexibly applying rules to periods of time
The German vowel “a” changes to the English “i”
Meme-controlled people
I am confused as to how the inverse of a certain function is found.
Why does a Star of David appear at a rally with Francisco Franco?
I got the following comment from a reputed math journal. What does it mean?
How difficult is it to simply disable/disengage the MCAS on Boeing 737 Max 8 & 9 Aircraft?
Python if-else code style for reduced code for rounding floats
et qui - how do you really understand that kind of phraseology?
What is "focus distance lower/upper" and how is it different from depth of field?
Counting models satisfying a boolean formula
As a new Ubuntu desktop 18.04 LTS user, do I need to use ufw for a firewall or is iptables sufficient?
Conditional format to show text based on specific values
How to prevent Excel rounding numbers or adding redundant 0's?Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique valuesColor-based text in Excel cellPainting Rows based on Cells' ValuesExcel conditional formatting with custom formatConditional Format based on a specific number within a formulaExcel: Conditional Formatting based on combination of cell values in a listweird “number in text format” behaviorUse Excel conditional formatting based on cell display, not content of cell formulaExcel: Conditional formatting if cell is not equal to one of multiple values
I need to conditionally format a cell, (g4) to display particular number (text 1-5) on a list of a possible 1-15 different numbers in (F4).
I can conditionally format G4 to show a 3 when F4 is 7 by selecting G4 Conditional Format - Create New Rule =IF(F4="7", "3", F4)
I'm just not sure how to use multiple values. All help appreciated.
microsoft-excel
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I need to conditionally format a cell, (g4) to display particular number (text 1-5) on a list of a possible 1-15 different numbers in (F4).
I can conditionally format G4 to show a 3 when F4 is 7 by selecting G4 Conditional Format - Create New Rule =IF(F4="7", "3", F4)
I'm just not sure how to use multiple values. All help appreciated.
microsoft-excel
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I need to conditionally format a cell, (g4) to display particular number (text 1-5) on a list of a possible 1-15 different numbers in (F4).
I can conditionally format G4 to show a 3 when F4 is 7 by selecting G4 Conditional Format - Create New Rule =IF(F4="7", "3", F4)
I'm just not sure how to use multiple values. All help appreciated.
microsoft-excel
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
I need to conditionally format a cell, (g4) to display particular number (text 1-5) on a list of a possible 1-15 different numbers in (F4).
I can conditionally format G4 to show a 3 when F4 is 7 by selecting G4 Conditional Format - Create New Rule =IF(F4="7", "3", F4)
I'm just not sure how to use multiple values. All help appreciated.
microsoft-excel
microsoft-excel
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
asked Dec 19 '16 at 22:25
Excel CrasherExcel Crasher
11
11
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
If you want to select from a range of possible text values, Conditional Formatting is not likely to give you what you're after. You'd be better off using an Index(Match, or a simple Vlookup.
It sounds like you're putting a number into F4, then you want G4 to display a value based on that number. So go to an empty area of your worksheet, or a different worksheet, and build your list of values:
Floor | Text
----------------
1 | Cat
4 | Dog
7 | Mouse
9 | Wombat
13 | Indricothere
Floor here is the lowest value that should trigger a given result. Then in G4, you can create your Vlookup:
=VLOOKUP($F4,Sheet2!$A$2:$B$6,2,TRUE)
The formula will find the row that has the largest value that is less than F4, then return the value from column 2 of the same row.
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
add a comment |
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%2f1158278%2fconditional-format-to-show-text-based-on-specific-values%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
If you want to select from a range of possible text values, Conditional Formatting is not likely to give you what you're after. You'd be better off using an Index(Match, or a simple Vlookup.
It sounds like you're putting a number into F4, then you want G4 to display a value based on that number. So go to an empty area of your worksheet, or a different worksheet, and build your list of values:
Floor | Text
----------------
1 | Cat
4 | Dog
7 | Mouse
9 | Wombat
13 | Indricothere
Floor here is the lowest value that should trigger a given result. Then in G4, you can create your Vlookup:
=VLOOKUP($F4,Sheet2!$A$2:$B$6,2,TRUE)
The formula will find the row that has the largest value that is less than F4, then return the value from column 2 of the same row.
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
add a comment |
If you want to select from a range of possible text values, Conditional Formatting is not likely to give you what you're after. You'd be better off using an Index(Match, or a simple Vlookup.
It sounds like you're putting a number into F4, then you want G4 to display a value based on that number. So go to an empty area of your worksheet, or a different worksheet, and build your list of values:
Floor | Text
----------------
1 | Cat
4 | Dog
7 | Mouse
9 | Wombat
13 | Indricothere
Floor here is the lowest value that should trigger a given result. Then in G4, you can create your Vlookup:
=VLOOKUP($F4,Sheet2!$A$2:$B$6,2,TRUE)
The formula will find the row that has the largest value that is less than F4, then return the value from column 2 of the same row.
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
add a comment |
If you want to select from a range of possible text values, Conditional Formatting is not likely to give you what you're after. You'd be better off using an Index(Match, or a simple Vlookup.
It sounds like you're putting a number into F4, then you want G4 to display a value based on that number. So go to an empty area of your worksheet, or a different worksheet, and build your list of values:
Floor | Text
----------------
1 | Cat
4 | Dog
7 | Mouse
9 | Wombat
13 | Indricothere
Floor here is the lowest value that should trigger a given result. Then in G4, you can create your Vlookup:
=VLOOKUP($F4,Sheet2!$A$2:$B$6,2,TRUE)
The formula will find the row that has the largest value that is less than F4, then return the value from column 2 of the same row.
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
If you want to select from a range of possible text values, Conditional Formatting is not likely to give you what you're after. You'd be better off using an Index(Match, or a simple Vlookup.
It sounds like you're putting a number into F4, then you want G4 to display a value based on that number. So go to an empty area of your worksheet, or a different worksheet, and build your list of values:
Floor | Text
----------------
1 | Cat
4 | Dog
7 | Mouse
9 | Wombat
13 | Indricothere
Floor here is the lowest value that should trigger a given result. Then in G4, you can create your Vlookup:
=VLOOKUP($F4,Sheet2!$A$2:$B$6,2,TRUE)
The formula will find the row that has the largest value that is less than F4, then return the value from column 2 of the same row.
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
answered Dec 19 '16 at 22:35
WerrfWerrf
710311
710311
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%2f1158278%2fconditional-format-to-show-text-based-on-specific-values%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
