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.

Conditional formatting for lowest number in a string
 

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 wrote in message
...
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.

Conditional formatting for lowest number in a string
 

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 wrote in message
...
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.

Conditional formatting for lowest number in a string
 

You're welcome. Thanks for the feedback!

Biff

"Phil Lewis" wrote in message
...
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 wrote in message
...
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.

Conditional formatting for lowest number in a string
 

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

HTH
--
AP

"Phil Lewis" <Phil a écrit dans le message
de ...
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.

Conditional formatting for lowest number in a string
 

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.