how do i find the lowest number in a column in Excel?

[Guest]

I need to identify and mark the lowest number in a column in Excel.

 

[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)

 

[Paul Sheppard]

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

 

[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 :

 

[Guest]

I tried what you suggested but and it did insert the formula into the range
but the format marked all cells in that column.