Selecting the 2nd highest value in a row.
 

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.

One way:

Select rows 1:3. Choose Format/Conditional Formatting....

CF1: Formula is =A1=LARGE(1:1,2)
Format1: Font/Bold


In article ,
"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.

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.