M
MKA808
I need to identify and mark the lowest number in a column in Excel.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=MIN(Range)
to tag it, select the range and do
format>conditional formatting formula is and
=MIN(Range)=A1
where A1 is the first cell of the range
Range needs to be a defined name or absolute reference
--
Regards,
Peo Sjoblom
(No private emails please)
to tag it, select the range and do
format>conditional formatting formula is and
=MIN(Range)=A1
where A1 is the first cell of the range
Range needs to be a defined name or absolute reference
--
Regards,
Peo Sjoblom
(No private emails please)
P
Paul Sheppard
MKA808 said:I need to identify and mark the lowest number in a column in Excel.
Hi MKA808
Try =MIN(A2:A50), change the range to suit, or Data > Filter
Autofilter and filter the column containing the data, the lowest numbe
will be top of the drop down lis
I
instruite
Select the range of cells where you want to format the minimum numbe
cell
Select Format -> Conditional Formating
In input box choose equal to
in the next box type =Min(range of cells) (make sure there are n
inverted commas in equation)
Click format and select the format way you want
Click OK
and the minimum value cell be formated the way you want :
cell
Select Format -> Conditional Formating
In input box choose equal to
in the next box type =Min(range of cells) (make sure there are n
inverted commas in equation)
Click format and select the format way you want
Click OK
and the minimum value cell be formated the way you want :
M
MKA808
I tried what you suggested but and it did insert the formula into the range
but the format marked all cells in that column.
but the format marked all cells in that column.