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