Finding lowest number in a column

[JRolph]

I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

 

[IML]

On 2002-03-06 15:15, JRolph wrote:
I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

You can use
=AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)
as your conditional formatting formula for cell a1 of column A.



_________________
Good Luck

"Give a man a fish, feed him for a meal,
Teach a man to fish, he will be drunk on a boat every Saturday"
This message was edited by IML on 2002-03-06 15:34

 

[JRolph]

Thank you very much! This works great.
One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?

 

[IML]

On 2002-03-06 19:26, JRolph wrote:
Thank you very much! This works great.
One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?

No, it will not. The conditional formatting formula will calculate based on the results of the formulas in your cells.
This message was edited by IML on 2002-03-07 11:24