COLORING LOWEST FIGURE IN A RANGE

I would like to format the lowest figure in a range to a chosen color.
Can anyone provide a formula or conditional formatting that will do
this. The range will cover about 20 rows.
Thanks

Hi,

assuming your data is in range A1:A10.

Use conditionql formatting (formula is)
In cell A1 :
=(A1=MIN(A$1:A$10))
an select the format you want for that cell.

NB : if there are several cells with the lowest value, they will all be highlighted.

Regards,

H.