View Single Post
  #5   Report Post  
MKA808
 
Posts: n/a
Default


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.