| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on a cell value
Do you know of a way to do the following:
I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is "direct" and another set of conditions if C5 is "stock" Example: If C5 is stock, then I want G5 to be Green if the value of G5 is 20% Orange if the value of G5 is 15% Red if the value of G5 is <15% If C5 is direct, then I want G5 to be Green if the value of G5 is 10% Orange if the value of G5 is 7% Red if the value of G5 is <7% Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on a cell value
CF/ Formula Is
=OR(AND(C5="stock",G520%),AND(C5="direct",G510%) ) for your green condition and so on -- David Biddulph "pcjjjr" wrote in message ... Do you know of a way to do the following: I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is "direct" and another set of conditions if C5 is "stock" Example: If C5 is stock, then I want G5 to be Green if the value of G5 is 20% Orange if the value of G5 is 15% Red if the value of G5 is <15% If C5 is direct, then I want G5 to be Green if the value of G5 is 10% Orange if the value of G5 is 7% Red if the value of G5 is <7% Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on a cell value
I understand the concept of this formula to put in the conditional formatting
area and put all three conditions in, but nothing changed in the formatting. I placed this formula (for one condition) in the cell to the right, and am receiving a "false" answer - that's why the formatting is not changing. I try changing the values to make the cells fit the two conditions, and still get the "false" answer to the formula. I will keep messing with it to try to get a "true" answer for one condition and then work from there. Any other help would be appreciated as well. "David Biddulph" wrote: CF/ Formula Is =OR(AND(C5="stock",G520%),AND(C5="direct",G510%) ) for your green condition and so on -- David Biddulph "pcjjjr" wrote in message ... Do you know of a way to do the following: I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is "direct" and another set of conditions if C5 is "stock" Example: If C5 is stock, then I want G5 to be Green if the value of G5 is 20% Orange if the value of G5 is 15% Red if the value of G5 is <15% If C5 is direct, then I want G5 to be Green if the value of G5 is 10% Orange if the value of G5 is 7% Red if the value of G5 is <7% Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on a cell value
My Error - I was missing a ) in the formula......changed the whole result.
I had cleared the cell next to the one that I wanted, and started from scratch with the "insert function" button so that I would have all of the syntax, parenthesis, quotations, etc. in the correct places and it worked. I then cut and pasted that value in to the conditional formatting and checked against the condition 2 and realized that I had the ) in the wrong location. Problem solved!!!! THANKS AGAIN FOR ALL OF YOUR HELP!!!!!! "pcjjjr" wrote: I understand the concept of this formula to put in the conditional formatting area and put all three conditions in, but nothing changed in the formatting. I placed this formula (for one condition) in the cell to the right, and am receiving a "false" answer - that's why the formatting is not changing. I try changing the values to make the cells fit the two conditions, and still get the "false" answer to the formula. I will keep messing with it to try to get a "true" answer for one condition and then work from there. Any other help would be appreciated as well. "David Biddulph" wrote: CF/ Formula Is =OR(AND(C5="stock",G520%),AND(C5="direct",G510%) ) for your green condition and so on -- David Biddulph "pcjjjr" wrote in message ... Do you know of a way to do the following: I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is "direct" and another set of conditions if C5 is "stock" Example: If C5 is stock, then I want G5 to be Green if the value of G5 is 20% Orange if the value of G5 is 15% Red if the value of G5 is <15% If C5 is direct, then I want G5 to be Green if the value of G5 is 10% Orange if the value of G5 is 7% Red if the value of G5 is <7% Any ideas? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on a cell value
There's usually a simple answer. Glad it worked.
-- David Biddulph "pcjjjr" wrote in message ... My Error - I was missing a ) in the formula......changed the whole result. I had cleared the cell next to the one that I wanted, and started from scratch with the "insert function" button so that I would have all of the syntax, parenthesis, quotations, etc. in the correct places and it worked. I then cut and pasted that value in to the conditional formatting and checked against the condition 2 and realized that I had the ) in the wrong location. Problem solved!!!! THANKS AGAIN FOR ALL OF YOUR HELP!!!!!! "pcjjjr" wrote: I understand the concept of this formula to put in the conditional formatting area and put all three conditions in, but nothing changed in the formatting. I placed this formula (for one condition) in the cell to the right, and am receiving a "false" answer - that's why the formatting is not changing. I try changing the values to make the cells fit the two conditions, and still get the "false" answer to the formula. I will keep messing with it to try to get a "true" answer for one condition and then work from there. Any other help would be appreciated as well. "David Biddulph" wrote: CF/ Formula Is =OR(AND(C5="stock",G520%),AND(C5="direct",G510%) ) for your green condition and so on -- David Biddulph "pcjjjr" wrote in message ... Do you know of a way to do the following: I have to choose if cell "C5" is either "direct" or "stock" - got that part down (validation) In cell G5, I want to have one set of conditional formatting if C5 is "direct" and another set of conditions if C5 is "stock" Example: If C5 is stock, then I want G5 to be Green if the value of G5 is 20% Orange if the value of G5 is 15% Red if the value of G5 is <15% If C5 is direct, then I want G5 to be Green if the value of G5 is 10% Orange if the value of G5 is 7% Red if the value of G5 is <7% Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting on one cell based on value in another | Excel Worksheet Functions | |||
| Conditional formatting based on another cell | Excel Discussion (Misc queries) | |||
| How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Linear Mode
