Thread: Conditional Formatting with 4 or more conditions
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
  
Posts: 740
Default 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
Reply With QuoteReply With Quote