View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Conditional Format?

Excel2003

I have a list of values (approx 30) of which some may repeat.

I wish to set cell pattern of "next to lowest" value.

=MIN(myrange) will set cell pattern containing lowest value, but I need to
be 1 click up from MIN value ... (I need to set cell pattern of "next to
lowest" value(s)).

Solutions? ... Thanks ... Kha