View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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