Formula to pick lowest number and format it

[PR]

I am trying to get a way that will look at a column of numbers... pick the
lowest number and then highlight that number...

i.e.
3.86
3.71
3.90
3.82
3.90
3.88


I would like the number 3.71 highlighted... there maybe instances of the
lowest number being in the column twice... that is ok... I would want both
highlighted...

can anyone help...

Regards - Paul

 

[Bob Phillips]

Use conditional formatting.

Select all the cells, I assume A1:A10
Goto to menu Format>Conditional Formatting
Change Condition 1 to formula Is
Add a formula of =A1=MIN($A$1:$A410)
Click Format button
Select the Pattern tab
Choose a colour
OK
OK



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[PR]

Bob,
thanks for this... but I do not quite get this part of the formula "
=A1=MIN($A$1:$A410)"

Regards - Paul

 

[Dave Peterson]

Change that 4 to a $:

=A1=MIN($A$1:$A$10)

Bob,
thanks for this... but I do not quite get this part of the formula "
=A1=MIN($A$1:$A410)"

Regards - Paul