0
The best way to do it is to use Conditional Formatting. This is particularly the case because the highest value may occur more than once in a range, and you want all cells with the highest value highlighted. Select the cells, and go to Conditional Formatting and pick Formula. Say your cells with the values in them were A2 to A200. Then your formula would be:
=A2=MAX($A$2:$A$200)
That would set the formatting for the first cell, and because it is applied to all cells, the A2 at the start will change to correspond to whichever cell it is on. We use A2 because it is the first cell selected, and is the active cell. Make sure quotes do not appear around the entire formula or it won't work.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
What is the formula for calculating maximum in Excel?
MAX. If you had a series of numbers in the range B1:B84 the following formula would show the largest of them: =MAX(B1:B84).
How do you make Microsoft Excel enter the greater value when choosing between a calculation and a set value for a formula?
You can use the MAX function. You could have the formula generating the value you want to test in one cell and then you the MAX function to choose between it and the fixed value. You could also have the formula generating the value built into the MAX. Say your generating formula is A2+B2 and is in cell C2 and your fixed value is 20, you could do this: =MAX(C2,20) You could also just put the formula into the MAX like this: =MAX(A2+B2,20)
What formula would you enter to calculate the ratio of the largest number MAX in the range Z1Z10 to the smallest MIN number in the same range?
Z1Z10 is not a range!
The MAX function determines the value in a selected range of values?
It determines the cell entry with the greatest value.
How do you get higher value in excel sheet?
The Max function will give you the highest value in a range of cells. So if you have numbers in all the cells from A1 to A15 and want to know what the highest one is, you would use the following formula, which you put into another cell outside of A1 to A15. =MAX(A1:A15)
What displays the highest value in a range in EXCEL?
The MAX Function. If you wanted to find the largest value in the range from cell A2 to cell A20, the formula would be: =MAX(A2:A20) You can also use the LARGE function. It is designed to be able to find not just the highest but other positions, like the second or third largest. You do this by specifying a number to indicate which position you want. Using 1 would give you the largest, as follows: =LARGE(A2:A20,1)
How do you calculate range in maths in Excel?
The range is the difference between the highest and the lowest values. You can find the highest using the MAX function less the value found by the MIN function. So if you wanted to get the mathematical range for the cell range A2 to A30, you would do this: =MAX(A2:A30) - MIN(A2:A30)
What is the command in autocalculate area displays the highest value in the selected range?
I didn't know there was one; I always make a formula with the MAX() function.
What does the MAX function do?
In a range of cells it can find the highest value. So if you had numbers in all the cells from A2 to A20 and wanted to find the highest you could use the following formula: =MAX(A2:A20)
What is the max range of 357 mag 180 gr bullets 7 barrel?
Max range is about 1000 meters. Max EFFECCTIVE range is around 75-100 meters.
What formula with functions can you enter to calculate the ratio of the maximum value in the range z1z10 to the minimum value?
It is max(z1,...,z10)/min(z1,...,z10).
