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

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

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.

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

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

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

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