Highlight the lowest number - only if it does not equal another va
 

I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal another va
 

Conditionally format A1:A6 with

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

Tyro

"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal another va
 

You could use this formula in a Conditional Format...

=AND(A1=SMALL(A$1:A$6,1),SMALL(A$1:A$6,1)<SMALL(A $1:A$6,2))

Rick


"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal another va
 

In thinking about it, I guess we could save 8 characters...

=AND(A1=MIN(A$1:A$6),MIN(A$1:A$6)<SMALL(A$1:A$6,2 ))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
You could use this formula in a Conditional Format...

=AND(A1=SMALL(A$1:A$6,1),SMALL(A$1:A$6,1)<SMALL(A $1:A$6,2))

Rick


"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and
all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal another va
 

Try this...

Select the range A1:A6
Goto the menu FormatConditional Formatting
Formula Is:

=AND(A1<"",A1=MIN(A$1:A$6),COUNTIF(A$1:A$6,A1)=1)

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal anothe
 

Thanks...

"Tyro" wrote:

Conditionally format A1:A6 with

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

Tyro

"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?

Highlight the lowest number - only if it does not equal another va
 

Thanks for all your help.

"JJ2356" wrote:

I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I do
not want any cells highlighted.

Any advice?