Eric,

What do you mean exactly by "any time"? Do you want it to be done
automatically without user interaction? In that case, you should use an event
which will compare the value in D2 and MAX(D3:D6), and sort the range
automatically.

If you agree to use the sort menu function, then you can have a conditional
formatting in cell D2, so it would have a yellow background for example if it
is not the largest value. Select "Formula Is" from the first combobox, then
copy "=D2<MAX(D3:D6)" (without quotes).

Stephane.