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
.
|