Conditional formatting for lowest number in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
you can also use "Cell Value is" - "Less Than" - and the following formula

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Needed for lowest three values in a Column 12
Conditional Formatting using Small 1
Finding the Lowest Number 3
Conditional Formatting in XL2007 3
Find the lowest value in a row 2
Conditional Formmating Help 2
Conditional formatting - getting input from another cell 6
Breaking a tie - Excel 2003 5

Back
Top