Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
I have different conditions in a cell.
If the cell value is either "awarded", "launched" or "high" the cell should have green pattern. If the cell value is "medium" the pattern should be yellow. And for "low" it should be "red. -- Product Business Manager Seating Johnson Controls Burscheid, Germany |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
This is really three conditions:
Condition 1: Cell value = "medium" then yellow Condition 2: Cell value = "low" then red Condition 3: Cell value = not medium or not low, then green. Dave -- Brevity is the soul of wit. "Philipp Ehrenstein" wrote: I have different conditions in a cell. If the cell value is either "awarded", "launched" or "high" the cell should have green pattern. If the cell value is "medium" the pattern should be yellow. And for "low" it should be "red. -- Product Business Manager Seating Johnson Controls Burscheid, Germany |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
One way:
CF1: Cell Value Is equal to "low" Format1: <patterns/<red CF2: Cell Value Is equal to "medium" Format2: <patterns/<yellow CF3: Formula Is =FIND("%"&LOWER(A1)&"%","%awarded%launched%high%") Format3: <patterns/<green In article , Philipp Ehrenstein wrote: I have different conditions in a cell. If the cell value is either "awarded", "launched" or "high" the cell should have green pattern. If the cell value is "medium" the pattern should be yellow. And for "low" it should be "red. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
However, there's an implicit 4th condition: blank or other than the
listed items. You may be exactly right, depending on the user's situation (there's not enough info in the OP to tell): If "awarded","launched","high","medium" and "low" are the only allowed values in the cell, then your statement is perfectly correct. OTOH, if the user can enter anything else, the green color from your list will imply incorrect information. In article , Dave F wrote: This is really three conditions: Condition 1: Cell value = "medium" then yellow Condition 2: Cell value = "low" then red Condition 3: Cell value = not medium or not low, then green. Dave |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
if u have 4 or more conditions, what is your fourth color ?
happy holidays. "Philipp Ehrenstein" wrote: I have different conditions in a cell. If the cell value is either "awarded", "launched" or "high" the cell should have green pattern. If the cell value is "medium" the pattern should be yellow. And for "low" it should be "red. -- Product Business Manager Seating Johnson Controls Burscheid, Germany |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
Fair point.
I assumed that the four values given were the ONLY possible values to be entered in the cells to which the conditional formatting was to be applied. Dave -- Brevity is the soul of wit. "JE McGimpsey" wrote: However, there's an implicit 4th condition: blank or other than the listed items. You may be exactly right, depending on the user's situation (there's not enough info in the OP to tell): If "awarded","launched","high","medium" and "low" are the only allowed values in the cell, then your statement is perfectly correct. OTOH, if the user can enter anything else, the green color from your list will imply incorrect information. In article , Dave F wrote: This is really three conditions: Condition 1: Cell value = "medium" then yellow Condition 2: Cell value = "low" then red Condition 3: Cell value = not medium or not low, then green. Dave |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with 4 or more conditions
assuming your current cell format pattern is gray
as per order of your preference format Conditional formatting 1. formula is : [type] =OR($C$11="AWARDED",$C$11="HIGH",$C$11="LAUNCHED") choose format patterngreenclick add 2. cell value is :[type] MEDIUM choose format patternyellowclick add 2. cell value is :[type] LOW choose format patternred happy holiday |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting on more than "4" Conditions | Excel Discussion (Misc queries) | |||
Conditional formatting wth more than 3 conditions | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions |