LinkBack URL
About LinkBacksI need to identify and mark the lowest number in a column in Excel.
I need to identify and mark the lowest number in a column in Excel.
Hi MKA808Originally Posted by MKA808
Try =MIN(A2:A50), change the range to suit, or Data > Filter > Autofilter and filter the column containing the data, the lowest number will be top of the drop down list
Paul
Select the range of cells where you want to format the minimum number cell
Select Format -> Conditional Formating
In input box choose equal to
in the next box type =Min(range of cells) (make sure there are no 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
Instruite
================
Ideas that work,
Concepts that sell.
================
=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.
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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks