View Single Post
  #3   Report Post  
Tony
 
Posts: n/a
Default

Thank You, this did exactly what I wanted it to do.

"Tony" wrote:

A B C D
1 -5 -15 40 -20
2 -50 -7 -3 60
3 50 -30 -10 -10

Is it possible to flag the 2nd highest value in a row.
example Row #1 -5
Row #2 -3
Row #3 -10 & -10 (both are the 2nd highest)
If so, can that cell be bolded or highlighted.
I do not know VBA, formulias Ok.
Thanks in advance.