Finding Highest and Lowest Value

[Brabed]

I am looking for a way to find the highest and lowest value within a selected range of data. I would preferably like for the highest and lowest values to be highlighted somehow within the data range. Thanks in advance.

 

[acw]

Hi

How do you want them highlighted??? The MAX and MIN functions should find the numbers, but how do you want them actioned? Macro? Conditional Formatting?


Tony

 

[Banker1]

There are two methods I can think of...

1. Using the MIN and MAX functions built into Excel and conditional formatting

2. Write a macro that will do it for you (must be triggered somehow though)

Is the range static or dynamic?

 

[Brabed]

Thanks, I forgot about MIN and MAX.