Formula to pick lowest number and format it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PR - 11 Nov 2006 10:04 GMT

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

Reply to this Message

Bob Phillips - 11 Nov 2006 10:12 GMT

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

Signature

HTH

Bob Phillips

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

> I am trying to get a way that will look at a column of numbers... pick the
> lowest number and then highlight that number...
[quoted text clipped - 14 lines]
>
> Regards - Paul

Reply to this Message

PR - 11 Nov 2006 10:23 GMT

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

Regards - Paul

> Use conditional formatting.
>
[quoted text clipped - 28 lines]
>>
>> Regards - Paul

Reply to this Message

Dave Peterson - 11 Nov 2006 12:40 GMT

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 "
[quoted text clipped - 41 lines]
> >>
> >> Regards - Paul

Signature

Dave Peterson

Reply to this Message