any time means without user interaction. The values in the range are not from
a formula, they are user entered numbers. I don't undersant the term event.

Just to be clear I would like excel to auto sort when a value in the D2:D6
range is changed.

"Stephane Quenson" wrote:

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.