Automatic formatting of minimum/maximum value in a range.

[Guest]

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

 

[Jason Morin]

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

 

[RagDyeR]

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!
==============================================

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