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

Good morning Manish

Try this. Highlight your range, and look where it displays the sum of the current range sum in the status bar at the botom of the screen. Right click, and select Max (or Min).

HTH

DominicB

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 Kumar@discussions.microsoft.com> wrote in message
news:5F47A650-8B9C-4F23-B151-D784193DDFB9@microsoft.com...
I want that if I select a range of numbers the minimum or maximum should be
selected by a single command