How are the values being entered into the cells? If it is as a result of
formulas in the cells? If so then the range will appear not to sort because
the fomulas will just recalcualte,

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Eric" wrote in message
...
I have a range say A2:D6 I would like to sort that range any time the
largest
value in range D2:D6 isn't at the top. I would like to sort highest to
lowest. is it possible to use a conditional format?