Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
I currently have 3 conditions for a column of cells, as an example;
Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Hi,
The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Sorry 'B10=3' should format to Orange!!
"Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Hi,
go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
That is my point,
i already have 3 Conditions, i cannot just 'enter there & select colour to orange' there is no option for this! "Eduardo" wrote: Hi, go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Can you not ignore condition 2? Format the column as no color. Then, if
AE10="No", it wouldn't change, so no need for that conditional format, and you'd have 3 to use. Please note, you can only have 3 conditions, so there is no way to perform a 4th. "gib21" wrote: That is my point, i already have 3 Conditions, i cannot just 'enter there & select colour to orange' there is no option for this! "Eduardo" wrote: Hi, go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
If i ignore condition 2 the data validation 'Yes/No' (column AE) changes to
orange because a 3rd cell is populated with no format unless there is a formula to ignore Condition 1 if 'No' is selected! "Sean Timmons" wrote: Can you not ignore condition 2? Format the column as no color. Then, if AE10="No", it wouldn't change, so no need for that conditional format, and you'd have 3 to use. Please note, you can only have 3 conditions, so there is no way to perform a 4th. "gib21" wrote: That is my point, i already have 3 Conditions, i cannot just 'enter there & select colour to orange' there is no option for this! "Eduardo" wrote: Hi, go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Hi,
Sorry but that's a limitation read this http://blogs.msdn.com/excel/archive/...13/480599.aspx "gib21" wrote: That is my point, i already have 3 Conditions, i cannot just 'enter there & select colour to orange' there is no option for this! "Eduardo" wrote: Hi, go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
Try
cond1 =B10=1 cond2 =B10=3 cond3 =AND(B10=2,AE10="Yes") You will get the default color if AE10 is "No" or has a value other than 1, 2 or 3. "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 3 Conditions???
That would bring us back to the 3 is your limit issue.
In that case, you'll need some Visual Basic code. May want to ask in the programming section to see fi they can give you some nice code to use to accomplish this. "gib21" wrote: If i ignore condition 2 the data validation 'Yes/No' (column AE) changes to orange because a 3rd cell is populated with no format unless there is a formula to ignore Condition 1 if 'No' is selected! "Sean Timmons" wrote: Can you not ignore condition 2? Format the column as no color. Then, if AE10="No", it wouldn't change, so no need for that conditional format, and you'd have 3 to use. Please note, you can only have 3 conditions, so there is no way to perform a 4th. "gib21" wrote: That is my point, i already have 3 Conditions, i cannot just 'enter there & select colour to orange' there is no option for this! "Eduardo" wrote: Hi, go to conditional formation, where the formula is and enter there B10=3 select you color to orange "gib21" wrote: Sorry 'B10=3' should format to Orange!! "Eduardo" wrote: Hi, The problem with what you want to achieve is that you have already give a condition to cell B10=2 (Condition 1). you stablish you wanted to be red If this was helpful, please click yes, thanks "gib21" wrote: I currently have 3 conditions for a column of cells, as an example; Condition 1 Format is Red =OR(B10=2,AE10="Yes") AE10 is 'Yes/No' dropdown Condition 2 Format is 'No Colour' =AE10="No" Condition 3 Format is 'Green' =B10=1 I need Condition 4 to be 'Orange' with the formula as =B10=2 I have '=COUNTA(AC7,AD7,AE7,AH7)' in column B. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Conditions Help | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |