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

> =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)
>
>
> "MKA808" <[email protected]> wrote in message
> news:[email protected]...
> >I need to identify and mark the lowest number in a column in Excel.
>
>