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
|