Conditional formatting for lowest number in a string

I have a column of numbers and want to color highlight the lowest number in
the column. However, I only want to color highlight if there is a clear
"winner". Ties should not activate the color. There is a posted article on
the MS site (article 909845) using an IF statment but it does not allow for
ties. Does anyone know how to do this.

Hi!

Assume the range in question is A1:A10.

=AND(A1=MIN(A$1:A$10),COUNTIF(A$1:A$10,A1)=1)

Biff

"Phil Lewis" <Phil [email protected]> wrote in message
news:[email protected]...
>I have a column of numbers and want to color highlight the lowest number in
> the column. However, I only want to color highlight if there is a clear
> "winner". Ties should not activate the color. There is a posted article
> on
> the MS site (article 909845) using an IF statment but it does not allow
> for
> ties. Does anyone know how to do this.

Worked great. Thanks for the quick response.
--
Phil Lewis


"Biff" wrote:

> Hi!
>
> Assume the range in question is A1:A10.
>
> =AND(A1=MIN(A$1:A$10),COUNTIF(A$1:A$10,A1)=1)
>
> Biff
>
> "Phil Lewis" <Phil [email protected]> wrote in message
> news:[email protected]...
> >I have a column of numbers and want to color highlight the lowest number in
> > the column. However, I only want to color highlight if there is a clear
> > "winner". Ties should not activate the color. There is a posted article
> > on
> > the MS site (article 909845) using an IF statment but it does not allow
> > for
> > ties. Does anyone know how to do this.
>
>
>

You're welcome. Thanks for the feedback!

Biff

"Phil Lewis" <[email protected]> wrote in message
news:[email protected]...
> Worked great. Thanks for the quick response.
> --
> Phil Lewis
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Assume the range in question is A1:A10.
>>
>> =AND(A1=MIN(A$1:A$10),COUNTIF(A$1:A$10,A1)=1)
>>
>> Biff
>>
>> "Phil Lewis" <Phil [email protected]> wrote in message
>> news:[email protected]...
>> >I have a column of numbers and want to color highlight the lowest number
>> >in
>> > the column. However, I only want to color highlight if there is a
>> > clear
>> > "winner". Ties should not activate the color. There is a posted
>> > article
>> > on
>> > the MS site (article 909845) using an IF statment but it does not allow
>> > for
>> > ties. Does anyone know how to do this.
>>
>>
>>

See conditional format for A1:A14 in: http://cjoint.com/?dxsgfobEPX

HTH
--
AP

"Phil Lewis" <Phil [email protected]> a écrit dans le message
de news:[email protected]...
> I have a column of numbers and want to color highlight the lowest number
in
> the column. However, I only want to color highlight if there is a clear
> "winner". Ties should not activate the color. There is a posted article
on
> the MS site (article 909845) using an IF statment but it does not allow
for
> ties. Does anyone know how to do this.

you can also use "Cell Value is" - "Less Than" - and the following formula

=SMALL($A$1:$A$10,2)

"Phil Lewis" wrote:

> I have a column of numbers and want to color highlight the lowest number in
> the column. However, I only want to color highlight if there is a clear
> "winner". Ties should not activate the color. There is a posted article on
> the MS site (article 909845) using an IF statment but it does not allow for
> ties. Does anyone know how to do this.