View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

How about cond. formatting?

1. Select the range.
2. Go to Format Conditional Formatting
3. Select "Formula Is" and copy in this:

=OR(INDIRECT("rc",0)=MAX(rng),INDIRECT("rc",0)=MIN (rng))

where "rng" is a defined name for your range.

HTH
Jason
Atlanta, GA

-----Original Message-----
I want that if I select a range of numbers the minimum

or maximum should be
selected by a single command
.