Automatic formatting of minimum/maximum value in a range.
 

I want that if I select a range of numbers the minimum or maximum should be
selected by a single command

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
.

What do you want to do with that information?

If it's strictly as a query, you could set the status bar to return the min
or max of a selected range.

Right click on the right side of the status bar and choose the calculation
that you wish to see displayed when a range of numbers is selected.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Manish Kumar" <Manish wrote in message
...
I want that if I select a range of numbers the minimum or maximum should be
selected by a single command