View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default 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?