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
formatconditional 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" wrote in message
...
I need to identify and mark the lowest number in a column in Excel.
|