Conditional Formatting with 4 or more conditions

[Philipp Ehrenstein]

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.

 

[Dave F]

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

 

[JE McGimpsey]

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>

 

[JE McGimpsey]

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.

 

[driller]

if u have 4 or more conditions, what is your fourth color ?

happy holidays.

 

[Dave F]

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

 

[driller]

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 > pattern>green>click add
2. cell value is :[type] MEDIUM
choose format > pattern>yellow>click add
2. cell value is :[type] LOW
choose format > pattern>red

happy holiday