K
Ken
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
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