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.