View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Conditional Format?

Excel2003 ... Conditional Format?

Range B10:B40 contains Text
Range C10:C40 contains numbers
Range G10:G40 "
Range K10:K40 "

I am looking for a Conditional Formula in Range B10:B40

B10 Conditions ... based on Ranges (C10:C40, G10:G40, K10:K40)

1: RED ... MAX Value
2: ORG ... 2nd Largest Value
3: YEL ... 3rd Largest Value

I know how to set Cond Colors, but I am stuck on Cond Formula to place in
Range B10:B:40 ... & Unfortunately, I am sure I have written this much more
complicated then it is ???

My "Thanks" in advance to the many Excel Magicians that support these boards
.... Kha